| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
10-11-2008, 05:45 AM
|
|||
|
|||
ANY dialect question:
select queryhi ,i have two tables emp,dept i want to find the dept name which has maximum number of employees
    
|
|
10-14-2008, 09:25 PM
|
|||
|
|||
|
ANY answer.
Re: select query
select name from departments where id in
( select dept_id from (select dept_id, count(dept_id) as count from users group by dept_id) t1 where count=(select max(count) from (select dept_id, count(dept_id) as count from users group by dept_id) t2) );
|
