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
- 3 Answers
- 6547 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
What is db stored procedure?
what is raid? : Sql server database administration
Explain sql delete command?
How can I tell if sql server is 32 or 64 bit?
Differentiate between delete and truncate.
What is the use of nvl work?
What are views used for?
What methods do you follow to protect from sql injection attack?
What are the properties of primary key?
What is difference between global temporary tables and local temporary tables?
Tell me in brief how sql server enhances scalability of the database system?
Which is the latest version of sql server and when it is released?
Define ACID properties in a Database?
What is the syntax to execute the sys.dm_db_missing_index_details?
Is foreign key unique?
