Change the view of result

ramankumar_04 · January 22nd, 2011, 12:24 PM

i have this query:
select count(year(hiredate)) no_of_emp, year(hiredate) hire_date from raman
group by year(hiredate)

gives below result:

no_of_emp hire_date
2 2008
3 2009
2 2010
2 2011

i need the result like below:

hiredate 2008 2009 2010 2011
no_of_emp 2 3 2 2

please let me know what should be query for this?

melvik · January 26th, 2011, 03:59 AM

in case of using SQL 2005 & UP

Code:

select * 
from 
(SELECT YEAR(hireDate) AS Yr FROM Raman) P
PIVOT ( 
	COUNT(Yr) FOR Yr
	IN([2008], [2009], [2010], [2011]))
AS pvt

ramankumar_04 · January 27th, 2011, 03:12 PM

Thank you so much Hovik...i am using 2005 and this query worked absolutely perfect....