تبلیغات
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




داغ کن - کلوب دات کام
نظرات() 
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