Which Department has MOST NUMBER of employees?
- 8 Answers
- 48574 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
What is literal?
What is oracle database 10g express edition?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Explain an exception and its types?
Explain the use of grant option in imp command.
what are archived logs?
What is blob datatype?
In what script is snap$ created? In what script is the scott/tiger schema created?
How to convert characters to numbers in oracle?
what are steps for interface? where is exchange rate defined in which table?
6. Display the client name and order date for all orders using the traditional method.
What are a query and state the different types of queries and their uses?
How will you differentiate between varchar & varchar2?
What is oracle data type?
Explain about functional dependency and its relation with table design?
