Interested to Buy Any Domain ? << Click Here >> for more details...
hi friends please answer this question ASAP:-
how to count the no. of employee in a each department
or
no. of employee in each location by using emp/dept table
- 7 Answers
- 8073 Views
- Indecomm, I also Faced
- E-Mail Answers
Answer Posted / ramandeep singh
SELECT Dept_Name, dept.Dept_ID, COUNT(*) AS 'no. of
employees' FROM dept
LEFT JOIN emp ON emp.Dept_ID = dept.Dept_ID
GROUP BY dept.Dept_ID, Dept_Name
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
why would you call update statistics? : Sql server database administration
Define right outer join in sql server joins?
What are the advantages of passing name-value pairs as parameters?
What are various limitations of the views?
What are magic tables in sql server?
What is replication with database mirroring? : sql server database administration
Can sql servers linked to other servers like oracle?
Explain can you implement data mining in ssrs?
where the connection string store in the database
How you can change a cross join into an inner join?
What is a mutating table error and how can you get around it?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
mention different types of relationships in the dbms?
What are the steps you will take to improve the performance of a poor performing query?
what is a transaction and what are acid properties? : Sql server database administration
