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
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Use of an integrity constraint is better to validate data. Explain
What is rowid and rownum in oracle?
What is oracle database client?
What are the attributes that are found in a cursor?
Explain about achiever in sql?
How to Truncate Table in Oracle
What is the difference between alert log file and tarce file ?
What are internal user account in oracle?
How to drop a tablespace?
State any two functions of oracle?
What the is the diff between local index and global index. give some example.
Is oracle a programming language?
Explain coalesce function?
What is SQL access advisor in Oracle?