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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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...

Part and Inventory Search

Back
Top