Tag Archives: RowNumber

RowNumber in Select Query

It is a common issue of many of the guys on how we can fetch a record based on its record number. It is really easy to get first 10 records using But when we want to fetch records in such a way say I need to fetch record from 40 to 50. This comes […]

Filter Records by RowNumbers in LINQ To SQL

In this tips we are going show how you can filter your data by RowNumbers that you assigned to your record(s). So to filter data in SQL (SQL server-2005) we use RowNumber function and than we use = or BETWEEN to filer data. In above query as you can see ROW_NUMBER() function assign number to […]