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
- 8340 Views
- Indecomm, I also Faced
- E-Mail Answers
Answer Posted / eswar mudamanchu
For example i am taking Emp table:
Select Deptid,Count(empid) from Emp
Group By Deptid Order By deptid
Select Location,Count(empid) from Emp
Group By Location Order By Location
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is equi join with example?
How each E-R model constructs can be mapped to the relational model?
What is the largest component inside a field?
What is the purpose of a table?
Define candidate key, alternate key, and composite key.
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
query processing
wat wil hapn if we give the both read and deny read permission to user?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
Is it possible to replicate data from sql server to oracle? : sql server replication
What is the difference between the 2 operating modes of database mirroring?
What is the language structure to add a record to a table?
What is optimization and its types?
What is difference between joins and subqueries?
What is advantage data architect?
