[dba-SQLServer] Accees Grouping Vs SQL

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