Which Department has MOST NUMBER of employees?
- 8 Answers
- 47901 Views
- IBM, LeadSquared, Mastek, I also Faced
- E-Mail Answers
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
List out the difference between commit, rollback, and savepoint?
Where are the settings stored for each instance in oracle?
What are the differences between char and varchar2 in oracle?
20. Using a set operator, display the client number of all clients who have never placed an order.
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
Explain the use of control file?
How to view all columns in an existing table?
Which environment variables are absolutely critical in order to run the OUI?
What privilege is needed for a user to create views in oracle?
State and explain about oracle instance?
What is a server parameter file in oracle?
How do I connect to oracle database?
How to divide query output into groups in oracle?
How to turn on or off recycle bin for the instance?
