Eine Einführung in


Select a record with the latest date

MS SQL Server
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.

Specific to MS SQL Server