Ask about a query in sql server

Revisions (4)

Comments & Discussions

Revisions

Compare	Revision	Minor	Date	Status	Editor
	publicly available	No	19 Nov '12 - 5:58	Available	AlluvialDeposit
Updates in content. 21 changes had been made.
	3	No	19 Nov '12 - 5:52	Available	AlluvialDeposit
Updates in content. 95 changes had been made.
	2	No	19 Nov '12 - 5:51	Available	AlluvialDeposit
Updates in content. 48 changes had been made.
	1	No	19 Nov '12 - 5:50	Available	AlluvialDeposit

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

AlluvialDeposit

Software Developer (Senior)

Norway

Member

Follow on Twitter

Microsoft Certified Solutions Developer (MCSD)

My personal websites/projects:
CRM1.no - A free to use norwegian crm software
Fakturax - A free to use norwegian invoice software

Alternative to Ask about a query in sql server

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.....

Type	Answer
Licence	CPOL
First Posted	18 Nov 2012
Views	0
Bookmarked	0 times

SQL-Server

Math Primers for Programmers

Get the Insider News free each morning.

Layout: fixed | fluid

		9,882,945 members (59,473 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using