Hi Guys!
I have a table that has 47,000,000 records. I need to get the first 1,000 rows in descending last_modified_date order.
I get as far as this:
select rownum, location_id, last_modified_userid,
last_modified_date from location
where rownum <= 1000
order by last_modified_date desc...