تبلیغات
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://tarnowska.pl
چهارشنبه 13 شهریور 1398 10:02 ب.ظ
My brother suggested I might like this website. He was totally right.
This post truly made my day. You cann't consider just how much time I had spent for
this info! Thank you!
http://kartuzy.info
چهارشنبه 13 شهریور 1398 09:49 ب.ظ
Hi there! I just wanted to ask if you ever have any trouble with hackers?
My last blog (wordpress) was hacked and I ended up losing months of hard work due to no data backup.

Do you have any methods to protect against hackers?
http://www.powiat24.pl
چهارشنبه 13 شهریور 1398 08:52 ب.ظ
If some one wishes to be updated with newest technologies after that he must be pay a quick visit this site and be
up to date all the time.
http://kartuzy.info
چهارشنبه 13 شهریور 1398 08:02 ب.ظ
This is really interesting, You are a very skilled blogger.
I have joined your feed and look forward to seeking more of your wonderful post.
Also, I have shared your web site in my social networks!
https://www.drawskopomorskie.com
چهارشنبه 13 شهریور 1398 06:20 ب.ظ
I was recommended this web site by means of my cousin. I'm no longer certain whether this put up is written by way of him as nobody else understand such specified
about my trouble. You're amazing! Thank you!
http://em.kielce.pl
یکشنبه 13 مرداد 1398 11:22 ب.ظ
We are a gaggle of volunteers and opening a new scheme in our
community. Your web site offered us with useful information to
work on. You have done a formidable activity and our
entire group will likely be thankful to you.
http://seven-pride.com/pl/tabletki-na-przyrost-masy-miesniowej.html
جمعه 11 مرداد 1398 06:17 ق.ظ
Hello. Permit me to introduce the author. His
name is Santiago. He is currently a accountant.
Some time ago he chose to call home in De. The thing I adore most flower arranging but Can not make it my profession really.

Check out my website here: http://seven-pride.com/pl/tabletki-na-przyrost-masy-miesniowej.html
http://produits-contre-la-calvitie.eu/foligain.html
جمعه 4 مرداد 1398 06:40 ب.ظ
The author is known by common history of Kristy.
Indiana is where we've been living for as well as
will never move. My friends say it's harmful to me but what Films doing is able to fitness
and I'll be starting something else along the earth .. The job
I've been occupying best is an information processing
police agency. He's not godd at design but you may choose
to check his website: http://produits-contre-la-calvitie.eu/foligain.html
http://tabletkinaodchudzanie.com.pl/silvets/
جمعه 4 مرداد 1398 09:45 ق.ظ
Hello friend. Let me introduce myself. I'm Jaime Kehoe but I am like people use
my full nickname. Software developing is how I support our
family and the salary may be really desirable. For years she's lived
in Montana but her husband wants them to shift.
What his as well as family him love is perform baseball but he's thinking
on starting something more. My wife and I keep a website.
It's advisable to look it over here: http://tabletkinaodchudzanie.com.pl/silvets/
http://schnell-viel-abnehmen-de.eu/sliminazer.html
جمعه 4 مرداد 1398 01:57 ق.ظ
Patsy is what you can call me and Towards the gym comfortable individuals
use complete name. For a while he's held it's place in Colorado in which he will
never move. After being out of my job for years I
became an interviewer and I don't think I'll change it anytime real soon. What I love doing to be able to act also now I'm hoping to earn money using it.

Check out targeted at low quality news on the website:
http://schnell-viel-abnehmen-de.eu/sliminazer.html
http://produit-efficace-pour-maigrir.eu/
پنجشنبه 3 مرداد 1398 05:57 ب.ظ
Hello. I want to introduce the author. His name is Santiago.
He is currently a accountant. Some time ago he chose to stay
in De. The thing I adore most flower arranging but Can not make
it my profession really. Check out my website here: http://produit-efficace-pour-maigrir.eu/
http://tabletkinaodchudzanie.com.pl/black-latte-dzialanie-sklad-opinie-cena-i-gdzie-kupic/
پنجشنبه 3 مرداد 1398 04:44 ب.ظ
Hello! Permit me to start by saying my name - Jaime however i don't like
when people use my full name. New York invariably is his interior.
He used become unemployed the good news is he
can be an interviewer and he's doing pretty good financially.
Acting is among the list of things he loves most people.
Her husband and her maintain a website. You might want in order to it out:
http://tabletkinaodchudzanie.com.pl/black-latte-dzialanie-sklad-opinie-cena-i-gdzie-kupic/
http://schnell-viel-abnehmen-de.eu/blacklatte.html
پنجشنبه 3 مرداد 1398 02:24 ب.ظ
Mallie Coggin is how I'm called and I feel comfortable when we use the full name.
The job I've been occupying walkman from sony is a bookkeeper actually something
I really enjoy. To act will be the thing I really most of
all. She currently lives in Montana. Check out most current news modest website:
http://schnell-viel-abnehmen-de.eu/blacklatte.html
http://na-zmarszczki.eu/marine-collagen.html
پنجشنبه 3 مرداد 1398 05:36 ق.ظ
Tawanna will be the name I really like to be called with and
I totally dig that legal name. Data processing happens when I support my
family members members. His family lives in Indiana
but they could have to one day or one. What she really enjoys doing is going to fitness it's
true she has time to take on new things. See what's new on this website here: http://na-zmarszczki.eu/marine-collagen.html
http://tabletkinaodchudzanie.com.pl/green-barley-plus-wyciag-z-mlodego-jeczmienia-opinie-dzialanie-i-sklad-produktu/
شنبه 29 تیر 1398 09:29 ق.ظ
Santiago is the place I'm called and my spouse
doesn't substantially at just about all. I've always loved living in colorado.
For years she has been working regarding interviewer and he or she will not
change it anytime today. Fishing associated with of issues he loves
most. My wife and I keep a website. You'll probably decide to to try it out
: here: http://tabletkinaodchudzanie.com.pl/green-barley-plus-wyciag-z-mlodego-jeczmienia-opinie-dzialanie-i-sklad-produktu/
http://brucia-grassi-efficace-it.eu/sliminazer.html
یکشنبه 23 تیر 1398 01:57 ق.ظ
Santiago is his name and he totally digs that tag. She used to
be unemployed acquire he is a data processing officer. Delaware
is the only place he's been keep in mind that. The favorite hobby for the children and me
is to collect badges nevertheless can't make it my profession really.
He's not godd at design but you'll probably decide to check his website: http://brucia-grassi-efficace-it.eu/sliminazer.html
http://tabletkinaodchudzanie.com.pl/eco-slim-opinie-dzialanie-sklad-i-gdzie-kupic-tabletki-na-odchudzanie/
شنبه 22 تیر 1398 08:14 ب.ظ
Greetings. The author's name is Santiago Vos but
he doesn't like men and women use his full name. Colorado is her birth
place but she may have to move one day or one. He is really fond of body building and now he has time to defend myself
against new important subjects. Meter reading is my normal work now
but soon I will be on a. Her husband and her maintain a web
site. You might like to check it out: http://tabletkinaodchudzanie.com.pl/eco-slim-opinie-dzialanie-sklad-i-gdzie-kupic-tabletki-na-odchudzanie/
http://prodotti-anti-caduta.eu/
شنبه 22 تیر 1398 05:59 ق.ظ
Greetings. Permit me to start by telling the author's name - Rico and he totally digs that information. Data processing is the I support my as well as the salary has been really extremely
rewarding. The favorite hobby for my kids and me is to unravel puzzles nevertheless can't let my profession really.
Montana is where I've always been living. Check out my website
here: http://prodotti-anti-caduta.eu/
http://trybunaczestochowska.pl/download/ntc-nr-180-01-09-2017/?wpdmdl=12946
جمعه 21 تیر 1398 06:30 ب.ظ
I got this web site from my buddy who informed me
on the topic of this web page and at the moment this time
I am visiting this web page and reading very informative content here.
4966.html
جمعه 21 تیر 1398 11:28 ق.ظ
Excellent pieces. Keep posting such kind of info on your blog.
Im really impressed by it.
Hey there, You have performed a great job. I'll definitely digg it and for my
part recommend to my friends. I am confident they'll be benefited
from this site.
http://lwowecki.info/pl/tag/1221/powiatowy-osrodek-rozwoju-edukacji.html
جمعه 21 تیر 1398 08:01 ق.ظ
Howdy! I could have sworn I've been to this blog before but
after browsing through a few of the articles I realized it's new to
me. Anyhow, I'm definitely delighted I found it and I'll be book-marking it
and checking back frequently!
http://naszinowlodz.pl/otwarcie-kawiarni-cafe-bona-w-inowlodzu/
جمعه 21 تیر 1398 07:50 ق.ظ
I read this post completely regarding the comparison of latest and preceding
technologies, it's amazing article.
http://www.szubin24.pl
سه شنبه 18 تیر 1398 10:34 ق.ظ
We're a bunch of volunteers and opening a new scheme in our community.
Your site offered us with valuable information to work on. You've performed
an impressive task and our entire neighborhood will likely be thankful
to you.
http://tygodnik.pl
سه شنبه 18 تیر 1398 08:55 ق.ظ
you are in point of fact a good webmaster. The web site loading pace
is incredible. It sort of feels that you are doing any unique
trick. Moreover, The contents are masterpiece. you've performed a excellent activity on this topic!
http://kartuzy.info
سه شنبه 18 تیر 1398 07:56 ق.ظ
I do not even know how I ended up here, but I thought this post was great.
I don't know who you are but definitely you're going to a famous blogger if you are not already ;) Cheers!
http://www.zamojska.pl
سه شنبه 18 تیر 1398 01:59 ق.ظ
I have read so many articles or reviews about the blogger lovers however this article is truly a nice paragraph, keep it up.
https://gostyn24.pl
سه شنبه 18 تیر 1398 01:56 ق.ظ
You are so interesting! I don't believe I've read anything like that
before. So wonderful to discover another person with
some unique thoughts on this subject matter.
Seriously.. thanks for starting this up. This web site is one thing that is needed
on the web, someone with some originality!
http://ekutno.pl
دوشنبه 17 تیر 1398 07:55 ب.ظ
Fantastic post however I was wondering if you could write a litte more on this subject?
I'd be very thankful if you could elaborate a little bit more.
Appreciate it!
http://tygodnik.pl
دوشنبه 17 تیر 1398 06:16 ب.ظ
An impressive share! I have just forwarded this onto a colleague who has been conducting a little
homework on this. And he actually ordered me lunch due to the fact that I discovered it for him...
lol. So allow me to reword this.... Thanks for the meal!!

But yeah, thanx for spending some time to discuss this issue here on your web
page.
http://gwe24.pl
دوشنبه 17 تیر 1398 05:29 ب.ظ
Greetings from Carolina! I'm bored to death at
work so I decided to check out your site on my iphone during lunch break.
I enjoy the info you present here and can't wait to take a look
when I get home. I'm shocked at how quick your blog loaded on my mobile ..
I'm not even using WIFI, just 3G .. Anyhow, very good blog!
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر


نمایش نظرات 1 تا 30


Admin Logo
themebox Logo