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

عملگر IN :

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

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

SELECT

                          *

FROM

               Student

WHERE

                                                                                                           ( Age    IN (21,25

City ID

Last Name

First Name

Age

ID

10

Bandpey

Mahla       

21

1

10

Alavi

Ali 

25

5

 

مثال : Query بنویسید که انهایی راکه FirstName  انها Sara,Samira است را نشان بده.

SELECT

                          *

FROM

               Student

WHERE

            FirstName    IN ('Sara' , 'Samira')

 

City ID

Last Name

First Name

Age

ID

20

Baghery

Samira

54

2

30

Panahi

Sara

36

3

 

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

NOT    ( FirstName    IN ('Sara' , 'Samira'))

City ID

Last Name   

First Name

Age

ID

10

Bandpey

Mahla        

21

1

40

Salimi

Mona

15

4

10

Alavi

Ali

25

5

 

 




داغ کن - کلوب دات کام
نظرات() 
How do you get rid of Achilles tendonitis?
دوشنبه 30 مرداد 1396 02:39 ب.ظ
Greetings! This is my first visit to your blog! We are a group of volunteers and starting a new project in a community in the same niche.
Your blog provided us valuable information to work on. You have done
a marvellous job!
belindamcclure1.soup.io
سه شنبه 24 مرداد 1396 09:43 ق.ظ
Please let me know if you're looking for a article author for your site.
You have some really good articles and I think I would be a good asset.

If you ever want to take some of the load off, I'd
really like to write some articles for your blog in exchange for
a link back to mine. Please blast me an email if interested.
Cheers!
Can Pilates make you look taller?
دوشنبه 16 مرداد 1396 01:28 ب.ظ
Great items from you, man. I've understand your stuff previous to and you're simply too great.
I actually like what you've got right here, certainly like what you are stating and the best way through which you
are saying it. You are making it enjoyable and you still take care
of to stay it sensible. I cant wait to learn far more from you.
This is actually a terrific site.
http://dillardyzsfvmjugo.jimdo.com
چهارشنبه 27 اردیبهشت 1396 11:26 ب.ظ
Hello! I simply wish to give you a huge thumbs up for your great information you've got here on this post.
I am returning to your site for more soon.
keirabagwell.bravesites.com
شنبه 9 اردیبهشت 1396 03:00 ب.ظ
Glad to be one of the visitants on this awe inspiring site :
D.
BHW
جمعه 1 اردیبهشت 1396 02:54 ق.ظ
Awesome blog! Do you have any suggestions for aspiring writers?
I'm planning to start my own site soon but I'm a little lost on everything.
Would you propose starting with a free platform
like Wordpress or go for a paid option? There are so many options out there that I'm completely overwhelmed ..

Any suggestions? Thanks!
manicure
یکشنبه 20 فروردین 1396 08:36 ب.ظ
First off I want to say great blog! I had a quick question in which
I'd like to ask if you do not mind. I was curious to find out how you center yourself and clear your mind prior to writing.
I have had trouble clearing my mind in getting my ideas out there.
I truly do take pleasure in writing however it just seems like the first 10 to 15 minutes are usually lost
simply just trying to figure out how to begin. Any suggestions
or tips? Cheers!
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo