how to get the no employee in each department including the
dept which has 0 employee
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 tns service name?
How can Oracle users be audited?
What are the general rules on data consistency?
How do I escape a reserved word in oracle?
if you ctreate table identity
How to store only time; not date and time?
What do you mean by merge in oracle and how can you merge two tables?
How many memory layers are in the oracle shared pool?
What is the parameter mode that can be passed to a procedure?
What is analyze command used for?
How to execute a stored procedure in oracle?
How to select some columns from a table in oracle?
What do you know about normalization? Explain in detail?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Why does for update in oracle 8 cause an ora-01002 error?