Stuart McLachlan
stuart at lexacorp.com.pg
Sat Sep 23 03:03:28 CDT 2006
They are if you use then on the Order By column :-) On 22 Sep 2006 at 19:59, Susan Harkins wrote: > MIN and MAX aren't interchangeable with FIRST and LAST. > > Susan H. > > Something that may help is the MIN or MAX arguments > > E.g. select min(StartDate) as 'First Date' from SomeTable > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > -- Stuart