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
- 7022 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
When is update_statistics command used?
Explain about local stored procedure?
How is sql server used?
Is it ok to shrink transaction log?
What is cached report?
Define union, union all, minus, intersect?
What is entity data services?
What is key attribute?
What part does database design plays a role in performance of an sql server-based application?
What is resource governor?
What is an index. What are the types?
How to delete all rows with truncate table statement in ms sql server?
Can you always create a cache of a report?
What is primary key and example?
What is a db view?
