WITH myTableWithRows AS ( SELECT (ROW_NUMBER() OVER (ORDER BY myTable.SomeField)) as row,* FROM myTable) SELECT * FROM myTableWithRows WHERE row = 3
var result = ( from m in dataContext.theTable select m).Skip(50).Take(1);
select * from( select id,name,row_number() over(order by id) as 'row' from student)as temp where row=n
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)