To get second row from a table

Posted by Denny under Sql Server category on 6/14/2012 | Points: 40 | Views : 1728

select top 1 * from (select top 2 * from EmpDetails1 order by empid) q order by empid desc

Bookmark It

Latest Code Snipptes