Which Department has MOST NUMBER of employees?
Answer Posted / ns
SELECT count(*), department_id
FROM employees
GROUP BY department_id
HAVING count(*) =
(SELECT max(count(*))
FROM employees
GROUP BY department_id)
| Is This Answer Correct ? | 40 Yes | 46 No |
Post New Answer View All Answers
How to manage transaction isolation level?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is a cognitive schema?
What are operators in oracle?
Explain the use of compress option in exp command.
What is the usage of analyze command in oracle?
What is blob datatype?
How to run the anonymous block again?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is a snapshot log?
What is the usage of synonyms?
What is the difference between I and G in Oracle?
How to initialize variables with default values?
What is the difference between "as" and "is" in an oracle stored procedure?