تبلیغات
SQL - نکته:

نکته:

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

نکته :بعد از دستور GROUP BY دستور WHERE نمی اید. بلکه دستور HAVING می اید. در شرط اگر  بخواهیم از حاصل یک ستون محاسباتی استفاده کنیم نمی توانیم اسم ستون محاسباتی را بیاوریم بلکه باید دستوری که ستون محاسباتی را ساخته است بیاوریم.

SELECT

AVG(Age)   As AvgAge,

MAX(Age)  As  MAXAge

FROM

    Student

WHERE

     CityID <> 10

GROUP BY

          CityID

HAVING

   AVG(Age)  <50   

 




داغ کن - کلوب دات کام
نظرات() 
How did the Achilles tendon get it's name?
شنبه 18 شهریور 1396 08:19 ب.ظ
I am sure this piece of writing has touched all the internet visitors, its really really fastidious paragraph on building up new blog.
Can you stretch to get taller?
دوشنبه 30 مرداد 1396 02:14 ب.ظ
Pretty nice post. I simply stumbled upon your weblog and wished to say that I have really enjoyed browsing your blog posts.
After all I will be subscribing for your feed and I hope you write once more very
soon!
grace0whitfield2.page.tl
سه شنبه 24 مرداد 1396 09:56 ق.ظ
You actually make it seem so easy with your presentation but I
find this matter to be really something which I think I would never understand.
It seems too complicated and very broad for me. I am looking forward for your next post,
I'll try to get the hang of it!
What causes burning pain in Achilles tendon?
یکشنبه 15 مرداد 1396 11:45 ب.ظ
My brother suggested I would possibly like this blog. He
was once entirely right. This publish truly made my day. You can not imagine simply how much
time I had spent for this information! Thanks!
foot pain in the arch
چهارشنبه 7 تیر 1396 06:10 ب.ظ
What's up i am kavin, its my first time to commenting anyplace,
when i read this post i thought i could also make comment due to this sensible paragraph.
ivelisseharnar.hatenablog.com
شنبه 30 اردیبهشت 1396 01:42 ق.ظ
Hello, I think your blog may be having web browser compatibility problems.

Whenever I look at your site in Safari, it looks fine however
when opening in I.E., it has some overlapping issues.
I just wanted to provide you with a quick heads up!
Aside from that, excellent blog!
BHW
پنجشنبه 31 فروردین 1396 03:12 ق.ظ
Wow that was unusual. I just wrote an extremely long comment but after
I clicked submit my comment didn't show up. Grrrr...

well I'm not writing all that over again. Regardless, just
wanted to say excellent blog!
manicure
یکشنبه 20 فروردین 1396 07:28 ب.ظ
It's going to be end of mine day, but before end I am reading this
fantastic paragraph to improve my knowledge.
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo