Table student containing 2 columns,Join date,Employee name.
Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar-
2008,4-feb-2008.Under Employee name 4 difeerent names
jaison,robin,binoy,rahul
Result set is,
Table containing 4-column name=jan,feb,mar,april,,beneath
these months count is given as 1,2,1,0 means these counts
representing number of emplooyees joined in a month(january
1employee,february 2 employee,march 1 employee,april 0
employee)
Can you give me the required sql query
Answer Posted / prg
SELECT Sum([1]) AS Jan, Sum([2]) AS Feb, Sum([3]) AS Mar,Sum([4]) as Apr,Sum([5]) as May,Sum([6]) as Jun,
Sum([7]) as Jul,Sum([8]) as Aug,Sum([9]) as Sep,Sum([10]) as Oct,Sum([11]) as Nov,Sum([12]) as Dec
FROM (SELECT Month(JoinDate) as Mon
FROM AAA) ps
PIVOT
(Count(Mon) FOR Mon IN ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])) AS pvt
group by [1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12]
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain the microsoft sql server delete command?
How to use values from other tables in update statements in ms sql server?
How many tables can be joined in SQL Server?
What is xml datatype?
What is the difference between functions and stored procedures?
What is the use of =,==,=== operators?
Can you explain powershell included in sql server 2008?
What is the downside of using udf?
How do I connect to sql server database?
When I delete any data from a table, does the sql server reduce the size of that table?
What do mean by xml datatype?
Why we need sql server?
How to execute multiple stored procedures at one time in sql server?
Describe and explain about SQL native client?
Do you know query execution plan?