تبلیغات
SQL - SUBQuery:

SUBQuery:

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

Query  که در دل یک Query دیگری قرار دارد.

ساختار اصلی SUB Query:

SELECT

      <Column_list>

FROM

        <data_Source>

WHERE

           <condition>

SUB Query که در قسمت SELECT می اید فقط باید یک سطر و یک ستون برگرداند.(یک مقدار)

مثال: از جدول CityInfo مقدار کمترین IDرا برگرداند.(البته در کنار اطلاعات پایین)

یعنی در کنارجدول student مقدار کمترین IDاز جدول CityInfo را نشان دهد.

SELECT   

                 ID,

                 LastName,

                 FirstName

FROM

                   Student

 




داغ کن - کلوب دات کام
نظرات() 
How do you get a growth spurt?
پنجشنبه 16 شهریور 1396 06:19 ق.ظ
Hi, just wanted to tell you, I enjoyed this blog post.
It was helpful. Keep on posting!
How do you get a growth spurt?
دوشنبه 30 مرداد 1396 08:14 ق.ظ
Excellent weblog here! Also your web site a lot up fast!
What web host are you using? Can I am getting your affiliate link on your
host? I desire my web site loaded up as fast as yours lol
Can you have an operation to make you taller?
یکشنبه 15 مرداد 1396 10:01 ب.ظ
I do accept as true with all the concepts you have introduced in your
post. They are very convincing and will certainly work.
Nonetheless, the posts are too quick for beginners. May just
you please lengthen them a little from next time? Thanks for the post.
nanceyKaylo.jimdo.com
سه شنبه 2 خرداد 1396 07:42 ق.ظ
Hello, i think that i saw you visited my web site thus i came to “return the favor”.I'm
trying to find things to improve my website!I suppose its ok to use a few of your ideas!!
BHW
جمعه 25 فروردین 1396 05:36 ق.ظ
You are so cool! I do not believe I've read through a single thing like this before.

So nice to find someone with genuine thoughts on this topic.
Seriously.. many thanks for starting this up. This site is one thing that is needed on the web, someone
with a bit of originality!
manicure
شنبه 19 فروردین 1396 02:08 ب.ظ
Hi there, after reading this remarkable paragraph i am
also cheerful to share my familiarity here with mates.
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo