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
- 7139 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 are the High-Availability solutions in SQL Server and differentiate them briefly?
Explain primary key in sql server?
How to remove duplicate rows from table?
What are sparse columns?
How to provide default values to function parameters?
What Is Rdbms?
What is the difference in accessing db between sql server vs sql azure?
Explain the third normal form(3nf)?
How to copy the tables, schema and views from one sql server to another?
How to get the definition of a view out of the sql server?
How can you check the version of sql server?
Do you know what are different types of replication in sql server?
How to create a store procedure with encryption?
What is difference between drop truncate and delete?
What is log shipping?
