Maximum ROWNUM Query

[Mr.Hanky]

Hey Allison;
Could you do something like this.
SELECT date_from, date_to from table_name
WHERE date_from = (select MAX(date_from) from table_name)
AND date_to =(select MAX(date_to) from table_name)
AND date_from IS NOT NULL;

Or am I just talking poo?
MH

[Edited by Mr.Hanky on 08-23-2001 at 08:59 AM]