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
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to delete multiple rows from a table in oracle?
What is a table in oracle?
What is a cognitive schema?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What is difference between cartesian join and cross join?
What is a schema in oracle?
What is a lookup table in oracle?
Explain parameter file in oracle.
Explain coalesce function?
20. Using a set operator, display the client number of all clients who have never placed an order.
What is PL/SQL ?
what are the advantages of running a database in archive log mode?
Can we store images in oracle database?
What are the different types of synonyms?