Interested to Buy Any Domain ? << Click Here >> for more details...
Which Department has MOST NUMBER of employees?
- 8 Answers
- 51420 Views
- IBM, LeadSquared, Mastek, I also Faced
- E-Mail Answers
Answer Posted / nannesaheb
SQL> Select Deptno,Count(*) from Emp
Group By Deptno
Having Count(*)=(Select Max(Count(*)) From Emp);
--If Any Queries Contact Me at nannesaheb.c@gmail.com
--Nannesaheb
| Is This Answer Correct ? | 8 Yes | 26 No |
Post New Answer View All Answers
Explain what are clusters?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
Explain the different normalization forms?
What is an oracle wallet?
How does one get the view definition of fixed views/tables?
How to define an anonymous procedure with variables?
Explain the types of exception?
What privilege is needed for a user to create indexes in oracle?
What is tns service name?
Explain cascading triggers.
What is tns name?
How would you change old and new values in an insert, delete and update triggers?
Is it possible to insert comments into sql statements return in the data model editor ?
Why should I use oracle database?
How to rename an index in oracle?
