تبلیغات
SQL - SUB Query:

SUB Query:

نویسنده :tamishan tamishan1
تاریخ:دوشنبه 6 آذر 1391-09:54 ب.ظ

SUB Query که در قسمت WHERE  می اید.

مثال: مشخصات شهری را برگردانید که دارای بیشترین جمعیت است.

SELECT  *   FROM      CityInfo

                WHERE 

                   Population=  (        

SELECT

               مقدار بیشترین جمعیت را نشان می دهد.               MAX (population)                                                       

FROM

              CityInfo    )                           

 

 

 

شکل اصلی دستور:

SELECT  *   FROM      CityInfo

    WHERE

           Population=  (SELECT   MAX (population)   FROM   CityInfo    )   

 




داغ کن - کلوب دات کام
نظرات() 
Can exercise increase your height?
پنجشنبه 16 شهریور 1396 07:49 ق.ظ
Hi there just wanted to give you a quick heads up. The text in your article seem to be running off the screen in Chrome.
I'm not sure if this is a formatting issue or something
to do with internet browser compatibility but I thought
I'd post to let you know. The style and design look
great though! Hope you get the problem resolved soon. Cheers
yellowjail2256.wordpress.com
سه شنبه 24 مرداد 1396 11:44 ق.ظ
WOW just what I was searching for. Came here by searching for SUB
What do you do for Achilles tendonitis?
سه شنبه 17 مرداد 1396 05:54 ق.ظ
Very nice article, just what I wanted to find.
Where is the Achilles heel?
دوشنبه 16 مرداد 1396 07:55 ق.ظ
I really like what you guys tend to be up too. This kind of clever work
and coverage! Keep up the great works guys I've incorporated
you guys to our blogroll.
manicure
یکشنبه 20 فروردین 1396 08:59 ب.ظ
constantly i used to read smaller posts that also clear their motive, and that
is also happening with this piece of writing which I am reading here.
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo