Select a record with the latest date

From SQLZOO
Revision as of 15:27, 17 July 2012 by Marek (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Select a record with the latest date.

schema:gisq

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)