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
- 8439 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 the concept of recursive stored procedure.
Is there any difference between the primary key and unique key?
How to list all dsn entries on your local machine using odbc_data_source()?
What is format parameter in ssrs?
Where sql server usernames and passwords are stored in a sql server?
What is identity?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
Is it possible for a stored procedure to call itself or recursive stored procedure?
How to list all user names in a database?
What is the server name in sql server?
What is buffer cash in sql server?
What is the definition for sql server 2000?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
How to run sql server 2005 books online on your local system?
Explain filtered indexes?
