How to retrieve data by specified row number.
SQL:
Code
1declare @n int
2set @n = 1
3select *
4from
5(
6 select row_number() over (order by 编号) #,* from tb
7) as A
8where A.# = @n
1declare @n int
2set @n = 1
3select *
4from
5(
6 select row_number() over (order by 编号) #,* from tb
7) as A
8where A.# = @n