SELECT * FROM (SELECT * , ROW_NUMBER() OVER (ORDER BY age) as Rn FROM test ) t
WHERE Rn=4
Showing posts with label Rownumber. Show all posts
Showing posts with label Rownumber. Show all posts
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
Subscribe to:
Posts (Atom)