managers having more than 3 emp working under him

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

You should ask the Human Resource department.

Ok, seriously now, how are we supposed the answer the question when we have no idea what the tables are like, how the columns are defined et cetera?

Please read the articles linked to in my signature on how to post a question to the forums.

ps: I hope this is not a homework assignment

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

sivaj2k Ten Centuries Points: 1188 More actions · Answer 2

Hi

I am using basic emp table.

select * from EMP a where exists(

select mgr from EMP b where a.MGR= b.mgr group by mgr having count(*)>2)

order by mgr

Regards

Siva Kumar J.

nkcherukuri SSC Rookie Points: 35 More actions · Answer 3

SSC Rookie

Points: 35

January 31, 2012 at 11:03 am

thanks shiv..