insert into dupemp(name,salary,deptno) values('1sd',4000,12)
insert into dupemp(name,salary,deptno) values('2sd',4000,12)
insert into dupemp(name,salary,deptno) values('3sd',4000,12)
insert into dupemp(name,salary,deptno) values('6sd',4000,12)
insert into dupemp(name,salary,deptno) values('4sd',4000,12)
Query:-
with CTE as(select *,ROW_NUMBER() over(order by (select 0))as row from dupemp )
select * from cte where row=(select min(row) from cte where row in(select top 2 row from cte order by row desc))
Output:-
Name salary deptno
6sd 4000 12