OFFSET/FETCH

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.

SYNTAX

NOTE:

  • 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