annamalai
Tuesday, December 14, 2010
Finding Nth row using ROW_NUMBER()
Finding Nth row using ROW_NUMBER()
Select * from (
select ROW_NUMBER() over(order by nTestNo desc) Row , nTestNo from Tests.TestMaster
) T where T.Row = 3
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment