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


Please Help Members By Posting Answers For Below Questions

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?

593


How to delete multiple rows from a table in oracle?

538


What is a table in oracle?

518


What is a cognitive schema?

508


1) Does oracle have any table which contain all the exceptions and it's code internally?

1256






What is difference between cartesian join and cross join?

564


What is a schema in oracle?

515


What is a lookup table in oracle?

512


Explain parameter file in oracle.

551


Explain coalesce function?

599


20. Using a set operator, display the client number of all clients who have never placed an order.

1772


What is PL/SQL ?

1083


what are the advantages of running a database in archive log mode?

1706


Can we store images in oracle database?

524


What are the different types of synonyms?

562