Scanning the last N rows

[Peter Wolf]

Hello all,

I want to retrieve the most recent N rows from a table, with some column 
qualifiers.

I can't find a Filter, or anything obvious in my books, or via Google.

What is the idiom for doing this?

Thanks
Peter