Home » SQL & PL/SQL » SQL & PL/SQL » To get department name
To get department name [message #19987] Mon, 22 April 2002 20:28 Go to next message
Gopal Raw
Messages: 19
Registered: January 2002
Junior Member
How to get the department name which has
maximum employess in oracle 8.

Report message to a moderator

Re: To get department name [message #19991 is a reply to message #19987] Tue, 23 April 2002 01:52 Go to previous message
Amit
Messages: 166
Registered: February 1999
Senior Member
try this...
select dept_type , count(*)
from dept_table
group by dept_type
having count(dept_type) in
(select max(count(dept_type))
from dept_table b
group by dept_type
)

Report message to a moderator

Previous Topic: Invalid data in Date fields!?!?!?
Next Topic: Re: ORA:01839
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 18:40:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.