select datename(mm,doj), count(studname) from student group by doj

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 / pradip jain

3 Answers
7159 Views
RND Soft, Wipro, I also Faced
E-Mail Answers

Answer Posted / pradip jain

select datename(mm,doj), count(studname) from student group
by doj

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1057

what are the Prerequisites for Replication?

11340

What is federation member?

114

What are constraints in microsoft sql server?

1116

What is the importance of a recovery model?

1040

What is a fill factor?

1076

Where views are stored in sql server?

973

What is model database? : SQL Server Architecture

1117

What is store procedure?

1050

What is statement level trigger?

976

Find columns used in stored procedure?

983

what is a schema in sql server 2005? : Sql server database administration

1016

What are subqueries in sql server?

1110

Can you explain different types of joins?

926

What is BCP? When does it used in sql server 2012?

1051