To get second row from a table

Denny
Posted by Denny under Sql Server category on | Points: 40 | Views : 1182
select top 1 * from (select top 2 * from EmpDetails1 order by empid) q order by empid desc

Comments or Responses

Login to post response