不太清楚
SELECT DATEPART(year, birthday) AS A1,
COUNT(*) AS A2,
min(DATEDIFF(year, birthday,GETDATE())) AS A3
FROM man
GROUP BY DATEPART(year, birthday)
SELECT DATEPART(year, birthday) AS A1,
COUNT(*) AS A2,
min(DATEDIFF(year, birthday,GETDATE())) AS A3
FROM man
GROUP BY DATEPART(year, birthday)
解决方案 »
- 关于表名和列名全是字母和数据序号的疑问,这样做有什么优点?
- 请教sqlserver2005如何复制表结构并且带着默认值啊?
- 高手帮忙看看sql出错的问题
- 在vfp程序中,如何获得sql存储过程中return返回的值?(output参数那种我会)
- 问:触发器中Set NoCount On 语句的作用
- 每天晚上自动对所有用户数据库清日志有必要吗?
- sql2008要怎么装啊= =#
- 计算所得的列规范下边的"是持久的",后面选"是"或"否"的区别是什么?
- MSSQL2008數據查詢操作超級慢的原因
- sql server和oracle互倒数据的问题
- 请问这样的SQL语句该怎么写(汇总统计的)
- update问题
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)
COUNT(*) AS A2,
DATEDIFF(year, birthday,GETDATE()) AS A3
FROM man
GROUP BY DATEPART(year, birthday), DATEDIFF(year, birthday,GETDATE())
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
)
aGROUP BY a1--结果
a1 a2 a3
----------- ----------- -----------
1990 1 14
2000 1 4(2 row(s) affected)
COUNT(*) AS A2,
DATEDIFF(year, birthday,GETDATE()) AS A3
FROM man
GROUP BY DATEPART(year, birthday),DATEDIFF(year, birthday,GETDATE())
,COUNT(*) AS A2
,DATEDIFF(year, birthday,GETDATE()) AS A3
FROM man
GROUP BY DATEPART(year, birthday),DATEDIFF(year,birthday,GETDATE())