how to get nth rows from table

Question

please tell me how to get nth rows from table in sql server 2008

Sibeesh Venu · Answer

Hi Please try this. SELECT * FROM ( SELECT ROW_NUMBER () OVER ( ORDER BY key ASC ) AS rownumber  columns FROM tablename ) AS foo WHERE rownumber n Please accept if it help you. Kindest Regards Sibeesh Venu www.SibeeshPassion.com

Sibeesh Venu · Answer

Well. That is the same code snippets I shared buddy.

Manoj Bhoir · Answer

Hi Try this one : WITH myTableWithRows AS ( SELECT (ROW_NUMBER() OVER (ORDER BY TableColumnName )) as row* FROM TableName ) SELECT * FROM myTableWithRows WHERE row = 3 @Sibeesh I think in your answer it should be equal to (=) instead of less than or equal to (

Upendra Pratap Shahi · Answer

select * from ( select idnamerow_number() over ( order by id) as ' row' from student) as temp where row=n

Nilesh Jadav · Answer

Sorry Sibesh it was like i was writing the answer and at the same time you posted the answer its just the coincidence dont worry i'll delete it. thank you