تبلیغات
SQL - عملگر BETWEEN :

عملگر BETWEEN :

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

مثال: Query بنویسید که  انهایی را نشان بده که سن انها بین   20تا 30 باشد.

انها بین   20تا 30 باشد.

SELECT

                          *

FROM

               Student

WHERE

                          Age  BETWEEN    20 AND  30

 

City ID

Last Name  

First Name

Age

ID

10

Bandpey

Mahla       

21

1

10

Alavi

Ali 

25

5

 

اما با اضافه کردن NOT به اول این دستور،این دستور برعکس عمل می کند.

NOT  (Age  BETWEEN    20 AND  30)      

Age   NOT BETWEEN    20 AND  30




داغ کن - کلوب دات کام
نظرات() 
How can I increase my height after 18?
دوشنبه 30 مرداد 1396 12:39 ب.ظ
Useful information. Lucky me I found your web site by chance, and I'm shocked why
this twist of fate did not took place in advance!
I bookmarked it.
plaza.rakuten.co.jp
سه شنبه 24 مرداد 1396 09:12 ق.ظ
I've been browsing online more than 3 hours today,
yet I never found any interesting article like yours. It is pretty worth enough for me.

Personally, if all site owners and bloggers made good content as you did, the internet will be a lot more useful than ever before.
What is distraction osteogenesis?
دوشنبه 16 مرداد 1396 08:44 ب.ظ
Howdy would you mind letting me know which hosting company you're working with?
I've loaded your blog in 3 different browsers and I must say this blog loads a lot quicker then most.
Can you suggest a good internet hosting provider at a reasonable price?
Kudos, I appreciate it!
BHW
سه شنبه 29 فروردین 1396 12:49 ق.ظ
This paragraph will assist the internet users for creating
new web site or even a blog from start to end.
manicure
یکشنبه 20 فروردین 1396 09:19 ب.ظ
Sweet blog! I found it while searching on Yahoo News.
Do you have any suggestions on how to get
listed in Yahoo News? I've been trying for a while but I never
seem to get there! Thank you
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo