select second lowest after value

Question

Hi i need to retrive a value from the table that value is second lowest values after value for ex :table having two zero values i need to retrive second zero's after value

Raja T · Answer

Hi Govind try like declare @tbltest table(id int value int) insert into @tbltest values(1230) insert into @tbltest values(1230) insert into @tbltest values(1230) select idvalue Rownum from (select idvalue(ROW_NUMBER() over (order by id)) as Rownum from @tbltest) as A where A.Rownum=2 more details check out below links http://www.c-sharpcorner.com/code/2787/delete-duplicate-records-in-table-all-columns-value-same.aspx http://stackoverflow.com/questions/19124662/how-to-use-row-number-in-update-clause