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

دستور GROUP BY :

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

کار با توابع جمعی:

Aggregated Functions

     SUM , AVG  , MIN ,MAX ,COUNT

مثال: این دستور تعداد رکورد ها را می شمارد.

SELECT 

        COUNT  (*) as  tedad

FROM

          Student   

Tedad

 

9

1

 
 

 

SELECT 

        COUNT  (*) as  tedad

FROM

          Student   

WHERE

          ID<3

Tedad

 

2

1

 



داغ کن - کلوب دات کام
نظرات() 
foot complaints
شنبه 18 شهریور 1396 04:55 ب.ظ
Fine way of describing, and nice paragraph to get facts regarding my presentation topic,
which i am going to deliver in institution of higher
education.
feet complaints
شنبه 18 شهریور 1396 12:40 ب.ظ
Nice blog here! Also your website loads up very fast! What web host are
you using? Can I get your affiliate link to your host?
I wish my web site loaded up as fast as yours lol
How do you prevent Achilles tendonitis?
دوشنبه 16 مرداد 1396 07:44 ق.ظ
I seriously love your blog.. Great colors & theme.

Did you create this website yourself? Please reply
back as I'm wanting to create my own blog and would like
to know where you got this from or what the theme is named.
Cheers!
http://TaiKalvig.bravesites.com/
سه شنبه 2 خرداد 1396 01:33 ب.ظ
Hi! I just wanted to ask if you ever have any issues with hackers?
My last blog (wordpress) was hacked and I ended up losing a few months of hard work due to
no back up. Do you have any solutions to stop hackers?
manicure
شنبه 2 اردیبهشت 1396 11:28 ق.ظ
I do not even know how I ended up here, but I thought this post was good.
I do not know who you are but definitely you're going
to a famous blogger if you are not already ;) Cheers!
BHW
چهارشنبه 30 فروردین 1396 11:03 ب.ظ
It's a shame you don't have a donate button! I'd without a doubt donate
to this fantastic blog! I guess for now i'll settle for bookmarking and adding
your RSS feed to my Google account. I look forward to new updates and will share this blog
with my Facebook group. Chat soon!
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo