Select a record with the latest date
Jump to navigation Jump to search
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)