Interested to Buy Any Domain ? << Click Here >> for more details...
Which Department has MOST NUMBER of employees?
- 8 Answers
- 51415 Views
- IBM, LeadSquared, Mastek, I also Faced
- E-Mail Answers
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
How can I combine multiple rows into a comma-delimited list in oracle?
Explain about your project and its relation to the current job position you are applying to?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How do I find the database name in oracle?
How to use subqueries with the in operator using oracle?
How can I get column names from a table in oracle?
How to run create database statement?
candidate key is subset of super key but not vice-verse explain
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How do I uninstall oracle client from windows?
What is a user role in oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How much memory your 10g xe server is using?
Difference between hot backup vs. Cold backup?
How to delete a user account in oracle?
