--find 2 or 3 lowest value in record
[sql]select min(empmarks )
from emp
where empmarks in (select top 3 empmarks from emp
order by empmarks DESC)[/sql]

--by kamal pandey for sql server only..