求一句sql,在线等(144分)

H

haodan110

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-25

• #1

有年龄、个人编号两个字段，要求出年龄在10~20，20~30，40~50的人数，新手上路，大家帮帮，小妹谢过

 

L

liangexcel

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-25

• #2

SELECT 年龄,COUNT(年龄) FROM
(SELECT (CASE WHEN 年龄 BETWEEN 10 AND 20 then
20 WHEN 年龄 BETWEEN 20 AND 30 then
30 WHEN 年龄 BETWEEN 30 AND 40 then
40 WHEN 年龄 BETWEEN 40 AND 50 then
50 else
60 END )FROM 表)B
GROUP BY B.年龄

 

B

breezee

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-25

• #3

select 年龄/10*10,count(*) from table1 group by 年龄/10*10
select 年龄/20*20,count(*) from table1 group by 年龄/20*20

 

8

8525310

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-25

• #4

好快的速度啊。。来晚了，，，55555
可怜啊。。。分没了

 

X

xiammy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-25

• #5

SELECT Round(p.Age/10)*10 AS 年龄, Count(*) AS 人数
FROM p
GROUP BY Round(p.Age/10);

 

K

kekexili

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-25

• #6

SELECT 年龄,COUNT(年龄) FROM
(SELECT (CASE WHEN 年龄 BETWEEN 10 AND 20 then
20 WHEN 年龄 BETWEEN 20 AND 30 then
30 WHEN 年龄 BETWEEN 30 AND 40 then
40 WHEN 年龄 BETWEEN 40 AND 50 then
50 else
60 END )FROM 表)B
GROUP BY B.年龄　　我认为是这样的和第一个朋友的意相同！～～～～

 

H

haodan110

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-25

• #7

谢谢.由于论坛出错,我以为信息没发出去,让大家久等,sorry