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
- 7095 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
What is a database schema in oracle?
How to work with data objects interactively?
What are the predefined tablespaces in a database?
What is a package in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is a database table in oracle?
What is a named program unit?
How to change system global area (sga) in oracle?
How to create a table in a specific tablespace?
What is the implicit cursor in oracle?
Can you tell me how to add new column in existing views?how?How is possible?
What is a system tablespace and when it is created?
What are the attributes that are found in a cursor?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What do you mean by cdb and pdb in oracle 12c?
