询问有关SQL Server中的查询 [英] Ask about a query in sql server

问题描述

大家好.我对AdventureWorks中的查询有疑问

我使用HumanResources.Employee和以下以下字段
员工编号，生日
我想知道每年有多少雇员被烧伤

Hello guys. I have a question about a query in AdventureWorks

i use HumanResources.Employee and these following fields
employeeid, birthdate
i want to know howmany employees burnt in every year

推荐答案

我想你提到每年出生. 按年份计数和分组:

I guess you ment born every year.
Count and Group by YEAR:

SELECT YEAR(BirthDate) As [Year], COUNT(*) as [Count]
FROM [HumanResources].[Employee]
GROUP BY YEAR(BirthDate)

结果:

Result:

Year	Count
1945	1
1946	3
1947	1
1948	1
1949	1
1950	10
1951	1
.....

这篇关于询问有关SQL Server中的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！