Difference between revisions of "Select a record with the latest date"

From SQLZOO
Jump to: navigation, search
(Created page with "Select a record with the latest date. <div class='ht'> <div class=params>schema:gisq</div> <div> There may be several records with the same date. <h4>There are two steps... (a...")
 
 
Line 4: Line 4:
 
<div>
 
<div>
 
There may be several records with the same date.
 
There may be several records with the same date.
<h4>There are two steps...
+
<h4>There are two steps... <br/>
(a) Find the latest date
+
(a) Find the latest date <br/>
(b) Select records with that date
+
(b) Select records with that date <br/>
 +
 
 
With a nested select we can do both of these in one go.</h4>
 
With a nested select we can do both of these in one go.</h4>
 
</div>
 
</div>

Latest revision as of 16:27, 17 July 2012

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