how to get the no employee in each department including the
dept which has 0 employee
Answer Posted / mahesh madala
select d.deptno,count(ename)no_of_emps from emp e,dept d
where d.deptno = e.deptno(+)
group by d.deptno
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to display employee records who gets more salary than the average salary in the department?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How will you identify oracle database software release?
How to create an oracle database?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is oracle host variable?
How to turn on or off recycle bin for the instance?
Explain the different normalization forms?
What is dual table oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What happens if you lost a data file?
What privilege is needed for a user to delete rows from tables in another schema?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What is recycle bin in Oracle?