Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7019 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 trigger and different types of Triggers?
What is it unwise to create wide clustered index keys?
Explain forward - only cursors?
What is self contained multi valued query?
What information is maintained within the msdb database?
Explain the difference between cross join and full outer join?
Why the trigger fires multiple times in single login?
How you can change the database name in SQL SERVER?
what method you can use to reduce the overhead of Reporting Services data sources?
How to transfer data from a cursor to variables with a "fetch" statement?
What is the difference between char and varchar2 datatype in sql?
Write a SQL queries on Self Join and Inner Join.
what's the difference between a primary key and a unique key? : Sql server database administration
What the different components of Replication and what is their use?
What are cascading parameters in ssrs reports?
