last 25 records from a dataset - Mailing list pgsql-novice

From Brian Scandale
Subject last 25 records from a dataset
Date
Msg-id 5.1.0.14.2.20020706163958.05f9d330@mail.attbi.com
Whole thread Raw
In response to Importing dbf files to postgresql  (John Dougherty <jwd@softcom.net>)
Responses Re: last 25 records from a dataset
List pgsql-novice
I am looking for the correct way to retrieve the last 25 records from a dataset without having to first retrieve the
entiredataset to pull out the last 25. 

The potential dataset can be very large... 10,000 records that match the query... yet I only can use the most recent
25.

my first idea is:

SELECT *
FROM table
WHERE thisField=thatValue etc...
ORDER BY table_id DESC
LIMIT 25

But I'm not confident in this and looking for a yeah or nay from a guru or two or three.

Thanks,
Brian




pgsql-novice by date:

Previous
From: Josh Jore
Date:
Subject: Re: Importing dbf files to postgresql
Next
From: Jason Friedman
Date:
Subject: Re: last 25 records from a dataset