Select a record with the latest date

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)

DATE and TIME Operations

Date and time types

Format a date and time

Specify a date

Match a range of dates

Subtract dates

INTERVAL of time

Components of date

Date functions

Date arithmetics

Select the oldest person

Select a record with the latest date

YYYYMMDD date format

Getting the latest record