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
7280 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 to add a new dsn with the odbc driver for sql server?

1114

What is scheduled job and how to create it?

1037

What are built in functions?

1069

Which rendering formats are affected by the pagesize properties?

151

What are parameterized reports?

204

What is a not null constraint?

1088

Do you know the isolation level that sql server support?

1005

How many joins in sql server?

1004

what is unique and xaml nonclustered index

1102

What samples and sample databases are provided by microsoft?

1089

What is exclusive locks?

1014

How to add more data to the testing table in ms sql server?

1167

What is mean by candidate key?

1063

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

1033

What are the different sql server versions?

1034