Thanks for your response MH

However I don't need the Max(date_from) and max(date_to), what I want is the details from the last time an entry was inserted into the table.

This might be a much smaller date range.

As a bit of background, this table is populated from a PeopleSoft Panel, the date's are selected by the user to decide what information they wish to view, this could change frequently, only the most current date range is valid, although the table will hold all historical information.

There is no other field that I can use to uniquely identify which row is the most current (other than rowid).

I understand that this isn't the most efficient way of doing things, unfortunately I have no choice.

Thanks

Alison