Select a record with the latest date

From SQLZOO
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)
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense