sql get the latest record with a given value code example Example: get latest record in sql ex: SELECT TOP 1 * FROM [TABLENAME] ORDER BY id DESC