• An other solution is:

    declare @n int

    select min(your_field) from your_table where your_field in

    (select top @n your_field from your_table order by your_field desc)

    For me is more elegant.

    Adrian