Tuesday, March 17, 2009

Get 2nd(second) lowest sallery using sql

select top 1 * from (select top 2 * from sallery_tbl order by usallery asc) as Sallery order by USallery desc

where Sallery_tbl is table name and usallery is column name

No comments: