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
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
How to scale out a federation by Sql statement?
Does the order of columns in update statements matter?
How do I debug a stored procedure in sql server?
What is SQL Azure Fabric?
What is log shipping?
How to download and install the scaled-down database adventureworkslt?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
How to replace the Query Result 'Null Value' with a text ?
What is the difference between function and stored procedure in sql server?
Mention the differences between substr and charindex in sql server.
List out the differences between global and local temp tables in sql server?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
Can we write a distributed query and get some data which is located on other server and oracle database?
What are cursors and when they are useful?
What are the different types of collation sensitivity in sql server?