Post
Ask Question

Selecting Specific set of Rows using OFFSET and FETCH in SQL

We can use OFFSET and FETCH keywords to select specific number of rows in SQL Select query. 
  1. SELECT *  
  2. FROM Tablename  
  3. ORDER BY colname  
  4. OFFSET 0 ROWS  
  5. FETCH NEXT 10 ROWS ONLY  
The above query will returns first 10 records. 
  1. SELECT *  
  2. FROM Tablename  
  3. ORDER BY colname  
  4. OFFSET 10 ROWS  
  5. FETCH NEXT 10 ROWS ONLY  
Above query will returns records 11 to 20.
 
Likewise you can increase OFFSET values to get next set of records.