Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Queries with Aggregate Functions Expand / Collapse
Author
Message
Posted Wednesday, May 27, 2009 5:02 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 29, 2014 2:57 AM
Points: 1,098, Visits: 1,222
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


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
Post #723957
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse