Tuesday, August 3, 2010

To select nth row From a table

declare @num as int
set @num=3
select * from table1 a where @num=(select count(*) from table1 b where a.uid >= b.uid)

No comments:

Post a Comment