How Can I limit the select result ?

I want to select like this...

select * from any_table where table_field > any_no limit 10 order by
table_field DESC;

I want to select more than 1000 rows.
But, I want to view only 10 from maximum to maximum -10.

How can I ?

I want to make the search engin using Postgresql.
If more than 10000 rows, there's hard to query, I think...
Does anybody know about this ?

Please help me.