[dba-SQLServer] Accees Grouping Vs SQL

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





More information about the dba-SQLServer mailing list