OFFSET provides a starting row from which Server needs to start fetching rows. It is defaulted to 0.

FETCH provides the number of rows we want to fetch from the final query set.



  • OFFSET and FETCH can be used only with an order by clause.

  • OFFSET clause is mandatory with the FETCH clause

  • We cannot use TOP clause with OFFSET and FETCH

  • The OFFSET and FETCH row count must be an integer value and it does not support sub queries


©2020 by Pavan Lalwani. 

  • Udemy
  • Facebook
  • Twitter
  • YouTube
  • Linkedin