Which Department has MOST NUMBER of employees?
Answer Posted / aswini
select dept_id from emp group by dept_id having count(*)=(Select max(count(*)) From Emp group by dept_id)
Is This Answer Correct ? | 2 Yes | 14 No |
Post New Answer View All Answers
What is the difference between translate and replace?
how may join possible between (requisition with purchase order)
What is connection pool in oracle?
What happens if the update subquery returns multiple rows?
How to speed up webrick?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How to check the server version in oracle?
What is tns entry?
Point out the difference between user tables and data dictionary?
Explain about integrity constraint?
Can select statements be used on views in oracle?
How to delete a column in an existing table in oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Explain the use of file option in exp command.