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

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

951

What is normalization? Explain different forms of normalization?

1122

What is query optimization process?

984

Can you name some of the dml commands in sql?

1007

How do you know if sql server is running on your local system?

1019

What is snapshot parameter in ssrs?

150

Name the different type of indexes in sql?

942

Explain microsoft sql server functions?

1083

What is difference between global temporary tables and local temporary tables?

1208

How to delete a login name in ms sql server?

1046

What is the new security features added in sql server 2016? : sql server security

1087

What is the difference between functions and scalar functions?

1187

Explain triggers in sql?

927

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5897

What is the temp table?

899