[dba-SQLServer] Accees Grouping Vs SQL

Darren DICK darrend at nimble.com.au
Fri Sep 22 18:50:05 CDT 2006


Something that may help is the MIN or MAX arguments

E.g. select min(StartDate) as 'First Date' from SomeTable

That's what I use

HTH

Darran 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John Skolits
Sent: Saturday, 23 September 2006 7:00 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Accees Grouping Vs SQL

Is there an equivalent grouping argument for LAST and FIRST in SqlServer?




_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list