Select a record with the latest date
Revision as of 16:27, 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)