Devart Forums

Dear,

D 6 programming.
I like to make a query that gives as result the last 30 records in a table
I don't want to use SELECT * FROM tablename and then Query.Last
It takes to much time.
It should be like SELECT * LIMIT nn,30 FROM tablename
The nn being the number of records in the table minus 30
How can I get the nn number?
Any suggestions?
Thanks Teunis

This will works if you have an AutoInc field or DateTime field :

SELECT
x,
y
FROM
YourTable
ORDER BY
id desc limit 30