[thelist] SQL - Correlated Subquery??

Luther, Ron Ron.Luther at COMPAQ.com
Tue Dec 19 17:55:04 CST 2000


Hi Gang,


I have a table with (at least) three columns;

Region - North America, Europe, Asia

Process completion date - (completed program #6 at) 12/17/00 3:45:00am

Data "as of" date - (data for) 12/16/00 12:00:00am

(The table has - oh - let's say 300,000 records in it.  It is a "processing
history" table.)



What I'd really really like is to return 3 records - one showing me the
maximum "as of' date for each region.

This should be easy, I'm hanging my head, I'm just not getting it!



TIA,

Ron L.





More information about the thelist mailing list