Hi dude, If u use SQLSERVER 2005 this will help u....... -----------------

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

Question Posted / soorai ganesh

3 Answers
7183 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

Please Help Members By Posting Answers For Below Questions

Explain what stored procedure sp_replcounters is used for? : sql server replication

1518

What happens if null values are involved in bitwise operations?

1029

What are orphan records?

932

Explain how dts is used to extract, transform and consolidate data?

998

What is the difference between varchar and nvarchar?

941

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1947

what is the difference between delete table and truncate table commands? : Sql server database administration

1036

Explain rdbms?

1042

What are the types of indexing?

1084

In which sql server version report builder introduced?

149

What is difference between inner join and join?

1045

What is advantage data architect?

925

What is normalization 1nf 2nf 3nf?

1060

Explain the different types of backups available in sql server? : sql server database administration

928

What are scheduled tasks in sql server?

1085