Ask about a query in sql server

saeed.zarei

Rate me:

0.00/5 (No votes)

18 Nov 2012CPOL

1.8K

Hello guys. I have a question about a query in AdventureWorksi use HumanResources.Employee and these following fieldsemployeeid, birthdate i want to know howmany employees burnt in every year

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

1. Ask about a query in sql server

18 Nov 2012StianSandberg

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 Count1945 11946 31947 11948 11949 11950 101951 1.....

SQL-Server