Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by SQLLQS
-
Selecting most recent field in SQL Server
Normally this is what I would do: SELECT LAST(FIELD_1), LAST(FIELD_2) FROM TABLE_NAME GROUP BY SOME_REPEATING_FIELD But SQL Server does not have the LAST aggregate function. Now I also have a DATE field. I need to get the MAX(DATE) and get the FIELD_1 and FIELD_2 in its same entry...
