Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7273 Views
- RND Soft, Wipro, I also Faced
- E-Mail Answers
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
What is it unwise to create wide clustered index keys?
What is the use of commit?
What is the difference between a function and a trigger?
Do you know the cursor types?
What are partitioned views?
How do clustered indexes store data?
Explain alternate key, candidate key and composite key in sql server?
What are the restrictions that views have to follow? : SQL Server Architecture
What is cached report?
How to create a simple user defined function in ms sql server?
What are the benefits and tasks of object explorer? : sql server management studio
What are indexes in ms sql server?
What is save transaction and save point?
What are the tables in sql?
difference between Clustered index and non clustered index ?
