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

دستور GROUP BY :

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

 مثال: Query بنویسید که نشان دهد از هر کد شهر چند دانشجو داریم.

SELECT

          CityID,

          COUNT (*) as Tedad

FROM

    Student

GROUP BY

          CityID

 

City ID

Last Name

First Name

Age

ID

10

Bandpey

Mahla

21

1

20

Baghery

Samira

54

2

30

Panahi

Sara

36

3

20

Salimi

Mona

15

4

10

Alavi

Ali

25

5

 

Tedad

CityID

2

10

2

20

1

30




داغ کن - کلوب دات کام
نظرات() 
https://www.szuletesnapiajandekok.com/
جمعه 6 اردیبهشت 1398 07:18 ب.ظ
ルイヴィトンコピー販売,ルイヴィトンバッグコピー,ルイヴィトン財布コピー,ルイヴィトン激安,ヴィトン長財布コピー,ルイヴィトン偽物,ヴィトンコピー,ルイヴィトン ショルダーバッグコピー,ルイヴィトンダミエ財布コピー
http://www.myvibor.ru/interview.php
جمعه 6 اردیبهشت 1398 07:18 ب.ظ
エルメス財布コピー,偽物ブランド財布スーパーコピー超人気専門サイト問屋。
http://www.evreux-nature-environnement.org/v2/blog
جمعه 6 اردیبهشت 1398 07:17 ب.ظ
スーパーコピー,ブランド,ルイヴィトン,ロレックス
http://tamathawessinger.jimdo.com
سه شنبه 24 مرداد 1396 09:17 ق.ظ
For latest information you have to visit world wide web and
on the web I found this website as a finest web page for most
recent updates.
How do you get a growth spurt?
دوشنبه 16 مرداد 1396 08:02 ق.ظ
Hello! This is my first comment here so I just wanted to
give a quick shout out and tell you I truly enjoy reading your blog posts.

Can you suggest any other blogs/websites/forums that go over the
same subjects? Thanks a ton!
manicure
چهارشنبه 6 اردیبهشت 1396 06:10 ب.ظ
Good post. I learn something new and challenging on sites I stumbleupon every day.
It's always exciting to read through content from other authors and use a little something from
their sites.
manicure
شنبه 19 فروردین 1396 10:27 ب.ظ
Wow, incredible blog layout! How long have you ever been blogging for?
you made running a blog look easy. The total glance of your website is wonderful, as neatly as the content!
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo