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
- 7164 Views
- RND Soft, Wipro, I also Faced
- E-Mail Answers
Answer Posted / soorai ganesh
Hi dude, If u use SQLSERVER 2005 this will help u.......
-------------------------------------------------------
Create table student (studName varchar(50), doj smalldatetime)
insert into student values('Ganesh','05/26/2008')
insert into student values('Ramesh','03/26/2008')
insert into student values('Dinesh','03/26/2008')
insert into student values('Suresh','04/26/2008')
Select * from student
SELECT 'Students Admission by Monthwise',[3] AS March,[4] AS April,[5] AS May
FROM(
SELECT studName,
Month(doj) monthname
FROM student
) A
PIVOT
(
COUNT(studname)
FOR monthname in
([3],[4],[5])
) AS PVT
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
Explain what is it unwise to create wide clustered index keys?
What is the use of floor function in sql server?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
Can we call future method from trigger?
Can you explain what are commit and rollback in sql?
What is the difference between ‘having’ clause and a ‘where’ clause?
How to create an multi-statement table-valued function?
How to use linked server?
What are the purpose of Normalisation?
How does a profiler work?
What is a functions and types in sql server?
How to drop an existing schema in ms sql server?
Explain what are magic tables in sql server?
What is a trigger in sql server?
How to change the name of a database user?
