تبلیغات
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://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