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
- 8654 Views
- Indecomm, I also Faced
- E-Mail Answers
Answer Posted / ezhumalai
select d.dept_ID ,count(empid) from Emp a inner join Department b
on a.empid=b.empid
group by d.dept_ID
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain various On-Delete options in a DB table. Which is the default option?
How to find out what is the default collation in a database?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
List some case manipulation functions in sql?
Does index speed up select statements?
What are the filtered indexes?
What is the difference between clustered index and primary key?
Can we join two tables without primary key?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Differentiate between mongodb vs. Sql server?
What is the purpose of sql profiler in sql server?
List out the difference between union and union all in sql server?
What does Master database contains?
How to download and install the scaled-down database adventureworkslt?
What are the difference between primary key and unique key? : sql server database administration
