How to get the last 10 rows of a table?

[Anon]

How can I select the last 10 or so rows of a table when i use a \"ORDER BY DESC\" ?

I tried \"SELECT * FROM tablename ORDER BY date DESC LIMIT -10\" but it doesn\'t work

So I tried \"SELECT * FROM tablename ORDER BY date ASC LIMIT 10\" but it of cause gives me the results in the wrong order.

What can I do?

[crimaniak]

Like this

Select @result:=count() from...
select from... LIMIT @result-10

[Anon]

Thaaaaank you! That worked 🙂