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
7185 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

Define cursor locking

1009

What do you mean by 'normalization'?

1065

How to write a query with a left outer join in ms sql server?

985

What is instead of dml trigger?

1004

What is 1nf normalization form?

1039

What the different components of Replication and what is their use?

1070

What is index in an assignment?

954

What are the new scripting capabilities of ssms? : sql server management studio

1068

What is the difference between DataRow.Delete() and DataRow.Remove()?

1230

Is a primary key unique?

995

Explain what is raid and what are different types of raid levels?

1027

Explain index in sql server?

1021

What are different types of join?

1319

Where the sql logs gets stored?

991

Explain database normalization?

1231