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

دستور WHERE :

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

دستورات  شرطی

 مثال :  از جدول Student انهایی را که سن انها کمتر از 30 سال است را نشان بده.

                          

SELECT

                          *

FROM

               Student

WHERE

       Age < 30

 

City ID

Last Name

First Name

Age

ID

10

Bandpey

Mahla

21

1

40

Salimi

Mona

15

4

10

Alavi

Ali

25

5

مثال : از جدول Student انهایی را که سن انها بیشتر از 30 سال است را نشان بده.

SELECT

                          *

FROM

               Student

WHERE

    NOT [Age < 30]

City ID

Last Name

First Name

Age

ID

20

Baghery

Samira

54

2

30

Panahi

Sara

36

3

 

این دستور روبه رو مشابه دستور بالایی است ولی به فرم دیگر.

SELECT

                          *

FROM

               Student

WHERE

    Age >= 30

 

مثال : Query بنویسید که City ID هایی رو به ما نشان بده که = 10 باشد.

SELECT

                          *

FROM

               Student

WHERE

              City ID =10

City ID

Last Name

First Name

Age

ID

10

Bandpey

Mahla       

21

1

10

Alavi

Ali 

25

5




داغ کن - کلوب دات کام
نظرات() 
How long do you grow during puberty?
شنبه 18 شهریور 1396 05:26 ق.ظ
I blog frequently and I seriously thank you for your information. The article has
truly peaked my interest. I am going to book mark your blog and keep checking
for new details about once per week. I subscribed to your RSS
feed as well.
Where are the femur tibia and fibula?
پنجشنبه 16 شهریور 1396 01:54 ب.ظ
Right away I am going to do my breakfast, afterward having my breakfast coming
over again to read additional news.
Can you stretch to get taller?
پنجشنبه 16 شهریور 1396 07:21 ق.ظ
Your style is very unique compared to other folks I have read stuff from.
I appreciate you for posting when you've got the opportunity, Guess
I will just bookmark this blog.
Can better posture make you taller?
دوشنبه 30 مرداد 1396 09:45 ق.ظ
After I initially left a comment I seem to have clicked
the -Notify me when new comments are added- checkbox and from now on whenever a
comment is added I get 4 emails with the exact same comment.
There has to be an easy method you can remove me from that service?
Many thanks!
ivettebastianelli.wordpress.com
سه شنبه 24 مرداد 1396 11:18 ق.ظ
I have been exploring for a bit for any high-quality articles or weblog posts in this sort
of house . Exploring in Yahoo I eventually stumbled upon this
website. Reading this information So i'm happy to convey that I've a very just right uncanny feeling I came upon exactly what I needed.
I so much unquestionably will make certain to don?t disregard this website and provides it a glance regularly.
lidagustaveson.wordpress.com
پنجشنبه 21 اردیبهشت 1396 02:51 ب.ظ
Hi there would you mind sharing which blog platform you're working with?
I'm looking to start my own blog soon but I'm having a difficult time making a decision between BlogEngine/Wordpress/B2evolution and Drupal.
The reason I ask is because your layout seems different then most blogs and I'm looking for
something unique. P.S Sorry for being off-topic but I had to ask!
manicure
یکشنبه 20 فروردین 1396 07:28 ب.ظ
Someone essentially lend a hand to make severely articles I might state.
This is the first time I frequented your web page and thus far?
I amazed with the analysis you made to make this particular post incredible.
Great process!
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo