SELECT * FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY column_name) AS Rno,*
FROM Table_Name
)T
WHERE T.Rno = 7  -- If N is 7 other wise put ur nth value.

--For ex in dept table to select 5th record. Instead of 
this you can use &n so that it can ask row number

  select rnum, d.* from dept d, (select rownum rnum , 
deptno from dept ) e
where d.deptno = e.deptno and rnum = 5

declare @querry nvarchar(500)
declare @row varchar(10)
set @row = '5'

set @querry ='
select top 1 a.* from 
(select * from vdpmaster..usermaster
	 where usr_id not in
				(select top '
set @querry = @querry + @row + ' usr_id from 
vdpmaster..usermaster)
)a'
print @querry
EXEC sp_executesql @querry

Select top 1 * from 
(Select top n * from tbl order by column name asc)tbl1 
order by column name desc

select * from 
(select row_number() over(order by empid) rno,* from tbl)
tbl1
where tbl1.rno=n

Here N is for Nth record.

SELECT TOP 1 * FROM
     (SELECT TOP N * FROM 
        (SELECT Table.Coloumn1,Table.Coloumn2 from Table)
as d order by d.Coloumn1 desc) as p order by Coloumn1

select top 1 * from (select top n * from tbl order by col1 
desc) tbl order by col1 asc

where n = nth number in the list

select a.id,a.name from dept a
where
1= (select COUNT(b.id) from dept b where b.id>a.id)

Answer #7 should be 

select top 1 * from (select top n * from tbl order by col1 
asc) tbl order by col1 desc

where n = nth number in the list