[font="Verdana"]
Toreador (5/27/2009)
Mahesh Bote (5/27/2009)
[font="Verdana"]Answer should be 1, 2 and 4 as well as 2nd and 4th query are same.Mahesh[/font]
Look more carefully - the second query is 'GROUP BY ManagerID' and will work, the 4th is 'ORDER BY ManagerID' and will fail.
oops !!!, you are right. my mistake. [/font]
MH-09-AM-8694