Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the no employee in each department including the
dept which has 0 employee
- 5 Answers
- 7495 Views
- I also Faced
- E-Mail Answers
Answer Posted / priti
select count(emp_id) from employee group by dept_id;
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to list all indexes in your schema?
What is meant by recursive hints in oracle?
How do I uninstall oracle 11g?
defination of bitmap index
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What does sharding mean?
What are the different pseudo commands? Explain in general?
How would you begin to troubleshoot an ORA-3113 error?
How to generate query output in html format?
How will you differentiate between varchar & varchar2?
How can Oracle users be audited?
What is catalog in Oracle?
How to run create database statement again?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to rename a column in an existing table?
