Thursday, 4 June 2015

Rownumber function in SQL


SELECT * FROM (SELECT * , ROW_NUMBER() OVER (ORDER BY age) as Rn FROM test ) t
WHERE Rn=4
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)