• [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