Click here to Skip to main content
12,304,566 members (66,075 online)
Click here to Skip to main content

Tagged as

Stats

0 views
Posted

Ask about a query in sql server

, 18 Nov 2012 CPOL
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.....

Revisions


  

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

License

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

Share

About the Author

StianSandberg
Software Developer (Senior) Aurum AS
Norway Norway
Microsoft Certified Solutions Developer (MCSD)

Personal website:
stian.net

My projects:
CRM1.no - A free to use norwegian crm software
Fakturax - A free to use norwegian invoice software
Timeføring.no - A free to use norwegian timereg software
MittUtlegg - A free to use norwegian software for receipts
SupportWeb - A free to use norwegian software customersupport

You may also be interested in...

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.160530.1 | Last Updated 19 Nov 2012
Article Copyright 2012 by StianSandberg
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid