تبلیغات
SQL - دستور ORDER BY :

دستور ORDER BY :

نویسنده :tamishan tamishan1
تاریخ:سه شنبه 23 آبان 1391-01:06 ق.ظ

مرتب سازی به 2 صورت Ascending و Descending انجام می شود.

مثال: دستوری بنویسید که ستون ID را به صورت صعودی مرتب کند.

SELECT

                          *

FROM

               Student

ORDER BY

            ID   Asc

City ID

Last Name  

First Name

Age

ID

10

Bandpey

Mahla

21

1

20

Baghery

Samira

54

2

30

Panahi

Sara

36

3

40

Salimi

Mona

15

4

10

Alavi

Ali

25

5

 

مثال :Query بنویسید که اطلاعات 3 دانشجوی اخر جدول  Student را برگرداند.

SELECT   TOP3

                          *

FROM

               Student

ORDER BY

                                                                                                                                                               ID DESC                       


داغ کن - کلوب دات کام
نظرات() 
http://richard1bentley04.jigsy.com
سه شنبه 24 مرداد 1396 12:29 ب.ظ
Appreciating the hard work you put into your website and in depth information you present.
It's awesome to come across a blog every once in a while that isn't the same unwanted rehashed material.
Excellent read! I've saved your site and I'm including your RSS feeds to my Google account.
How do you treat a sore Achilles tendon?
دوشنبه 16 مرداد 1396 08:13 ب.ظ
I like the helpful info you provide in your articles.
I will bookmark your weblog and check again here frequently.
I'm quite sure I will learn a lot of new stuff right here!

Good luck for the next!
http://brittahotaki.jimdo.com/2014/12/31/symptoms-of-feet-corns
چهارشنبه 3 خرداد 1396 08:17 ق.ظ
Hi there, I do believe your site may be having internet browser compatibility problems.
Whenever I look at your website in Safari, it looks fine but when opening in IE, it has some overlapping issues.
I simply wanted to provide you with a quick heads up!
Other than that, great website!
BHW
دوشنبه 4 اردیبهشت 1396 07:35 ق.ظ
For newest information you have to go to see internet and on internet
I found this web site as a most excellent
site for most up-to-date updates.
BHW
جمعه 25 فروردین 1396 06:54 ب.ظ
Good day! I know this is somewhat off topic but I was wondering which blog platform are
you using for this site? I'm getting sick and tired of Wordpress because I've had
problems with hackers and I'm looking at alternatives for another platform.
I would be great if you could point me in the direction of a
good platform.
manicure
شنبه 19 فروردین 1396 01:03 ب.ظ
Hello, Neat post. There's an issue along with your web site in internet explorer, would
check this? IE still is the marketplace chief and
a large section of other folks will pass over your wonderful writing due to
this problem.
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo