Home Forums Article Discussions Article Discussions by Author Discuss content posted by Manish Sinha Queries with Aggregate Functions RE: Queries with Aggregate Functions

  • May 27, 2009 at 4:51 am

    #1000467

    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.