Home Forums SQL Server 2008 T-SQL (SS2K8) Obtaining unique data RE: Obtaining unique data
pietlinden
SSC Guru
Points: 63428
More actions
October 21, 2013 at 2:58 pm
#1660303
Use MAX
Group by the stuff before the dash.
CAST the stuff after the dash as a number, get MAX of it.