group by 怎样使用函数？

[luhongjun]

SELECT DATEPART(year, birthday) AS A1,
COUNT(*) AS A2,
DATEDIFF(year, birthday,GETDATE()) AS A3
FROM man
GROUP BY DATEPART(year, birthday)
这样是错诉的
SELECT DATEPART(year, birthday) AS A1,
COUNT(*) AS A2,
DATEDIFF(year, birthday,GETDATE()) AS A3
FROM man
GROUP BY birthday
是可以的。但我需要按年进行统计，我需要怎么办？
谢谢。

[Rotaxe]

不太清楚
SELECT DATEPART(year, birthday) AS A1,
COUNT(*) AS A2,
min(DATEDIFF(year, birthday,GETDATE())) AS A3
FROM man
GROUP BY DATEPART(year, birthday)

[luhongjun]

Rotaxe(程序员),谢谢，使用group by 必须都用聚集，给分

[leeboyan]

这样呢？
select convert(varchar(4),birthday,120)as a1,count(*)as a2,convert(varchar(4),getdate(),120)as a3 from man group by convert(varchar(4),birthday,120)

[leeboyan]

要么用left(convert())

[luhongjun]

哈，我以为是group by 不允许使用函数呢，把问题想偏了

[victorycyz]

SELECT DATEPART(year, birthday) AS A1,
COUNT(*) AS A2,
DATEDIFF(year, birthday,GETDATE()) AS A3
FROM man
GROUP BY DATEPART(year, birthday), DATEDIFF(year, birthday,GETDATE())

[LoveSQL]

--给你个例子，看看对你是否有帮助
declare @ table(birthday datetime,name varchar(20))
insert into @ select '2000-2-2','ligg' union all select '1990-3-3','wangy'
select a1,sum(a2) a2,sum(a3) a3
from

(
SELECT
DATEPART(year, birthday) AS A1,
COUNT(*) AS A2,
DATEDIFF(year, birthday,GETDATE()) AS A3
FROM @
group by birthday
)
a

GROUP BY a1

--结果
a1 a2 a3
----------- ----------- -----------
1990 1 14
2000 1 4

(2 row(s) affected)

[leeboyan]

csdn把兄弟们都饿疯了，看到一个三颗星星的200分，有或阿！

[leeboyan]

SELECT DATEPART(year, birthday) AS A1,
COUNT(*) AS A2,
DATEDIFF(year, birthday,GETDATE()) AS A3
FROM man
GROUP BY DATEPART(year, birthday)，DATEDIFF(year, birthday,GETDATE())

[realgz]

为什么大部分情况下我一想蹭分自然楼上就有好大一票人？！而且把话都给说完了。。

[leeboyan]

realgz(realgz)：又晚了？

[realgz]

最近 一想蹭分就晚。

[zjcxc]

--来接分

SELECT DATEPART(year, birthday) AS A1
,COUNT(*) AS A2
,DATEDIFF(year, birthday,GETDATE()) AS A3
FROM man
GROUP BY DATEPART(year, birthday),DATEDIFF(year,birthday,GETDATE())

[lynx1111]

空手来纯接分！

[xiaoliaoyun]

realgz(realgz) 和leeboyan(宝宝)升星还没有放分就跑来蹭分了.....