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