Select a record with the latest date
Revision as of 16:26, 17 July 2012 by Marek
Select a record with the latest date.
There may be several records with the same date.
There are two steps... (a) Find the latest date (b) Select records with that date With a nested select we can do both of these in one go.
SELECT * FROM totp WHERE wk= (SELECT MAX(wk) FROM totp)