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

دستور TOP:

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

:    برای نمایش تعدادی از سطر های اول لیست.

مثال: Query  بنویسید كه 3 سطر اول جدول Student  را برگرداند.            

Select TOP 3

        Last Name,

        First Name,

       City  ID,   

        ID

 FROM

                                                                                                                                                                                                                                                                                                                                    Student

 

City ID

Last Name

First Name

Age

ID

10

Bandpey

Mahla

21

1

20

Baghery

Samira

54

2

30

Panahi

Sara

36

3

 

در واقع می توانید N سطر اول را با استفاده از این دستور ببینید.

حالت دیگر این دستور بر حسب Persent (%) عمل می كند.

مثال: Query  بنویسید كه 15%   سطر اول را نشان دهید.

 

SELECT  TOP  15 Persent  

        Last Name,

        First Name,

       City  ID,   

        ID

 FROM

         Student

 

City ID

Last Name

First Name

Age

ID

10

Bandpey

Mahla

21

1

20

Baghery

Samira

54

2

 




داغ کن - کلوب دات کام
نظرات() 
http://pillole-per-pene-it.eu/beastgel.html
پنجشنبه 12 اردیبهشت 1398 03:24 ب.ظ
My brother recommended I might like this website. He was entirely right.

This post truly made my day. You cann't imagine simply how much time I had spent for this information!
Thanks!
grüner kaffee wirkung
سه شنبه 10 اردیبهشت 1398 02:57 ق.ظ
Your way of telling everything in this article is in fact pleasant,
every one can without difficulty know it, Thanks
a lot.
http://www.mirmetro.net/yekaterinburg/cruise_18_chkalovskaya
پنجشنبه 5 اردیبهشت 1398 05:44 ق.ظ
当サイトは最高級激安通信販売店 です。最高品質のスーパーコピーブランド 代引を激安価格で、
http://www.hotel-marine.com/reservation/
پنجشنبه 5 اردیبهشت 1398 05:42 ق.ظ
ャネルコピー、本物品質シャネルスーパーコピーバッグ偽物通販,シャネルスーパーコピー,シャネルバッグ偽物,シャネルバッグコピー
https://www.kidsupfrontvancouver.com/programs/cibc-theatre-for-all/
جمعه 30 فروردین 1398 06:45 ق.ظ
スーパーコピーブランドN級品ブランドコピー!スーパーコピー時計専門店!スーパーコピーのブランドバッグや
http://www.hksaustralia.com.au/products
جمعه 30 فروردین 1398 06:44 ق.ظ
ブランドコピー激安通販店
Peruanischer Maca Wirkung
پنجشنبه 29 فروردین 1398 01:43 ق.ظ
It's very easy to find out any topic on web as compared to textbooks,
as I found this post at this web site.
tonus fortis
چهارشنبه 28 فروردین 1398 08:30 ب.ظ
Wow, that's what I was looking for, what a stuff! existing
here at this webpage, thanks admin of this site.
http://potentiepillen.top/eracto.html
چهارشنبه 21 فروردین 1398 06:20 ب.ظ
When I initially commented I clicked the "Notify me when new comments are added"
checkbox and now each time a comment is added I get four emails with the same
comment. Is there any way you can remove people from that
service? Thank you!
http://pastillasparalapotencia2017.ovh/erogan.html
سه شنبه 7 اسفند 1397 11:02 ب.ظ
Normally I don't read article on blogs, but I wish to say that this write-up
very pressured me to try and do it! Your writing taste has been surprised me.
Thank you, very nice article.
http://www.produtos-para-disfuncao-eretil.eu/
دوشنبه 15 بهمن 1397 07:42 ق.ظ
I enjoy this site - its so usefull and helpfull.
http://agrandir-son-penis.eu/erozonmax.html
شنبه 13 بهمن 1397 03:08 ق.ظ
Thanks a lot! This is definitely an astonishing webpage!
Testo Ultra Wirkung
پنجشنبه 11 بهمن 1397 11:51 ب.ظ
Amazing Webpage, Stick to the great job. Many thanks!
machoman
پنجشنبه 11 بهمن 1397 09:10 ب.ظ
You have superb thing in this article.
http://jarvisyehmmrvorx.exteen.com
سه شنبه 24 مرداد 1396 11:55 ق.ظ
Terrific work! This is the kind of information that are supposed to be shared across the internet.
Shame on the search engines for no longer positioning this publish upper!

Come on over and discuss with my website . Thanks =)
foot pain heel
یکشنبه 4 تیر 1396 03:38 ق.ظ
Exactly what I was searching for, thank you for putting up.
http://kristabrennick.blogas.lt/
پنجشنبه 21 اردیبهشت 1396 12:16 ب.ظ
You need to take part in a contest for one of the best websites online.
I most certainly will recommend this website!
manicure
شنبه 19 فروردین 1396 11:50 ب.ظ
It's perfect time to make some plans for the longer term and it is time to be happy.
I have read this publish and if I may just I want to recommend you some attention-grabbing things or advice.
Maybe you could write subsequent articles referring to
this article. I wish to learn more issues about it!
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo