What is the purpose of the OFFSET clause when used with LIMIT?

SQL Fundamentals Medium

SQL Fundamentals — Medium

What is the purpose of the OFFSET clause when used with LIMIT?

Key points

  • OFFSET skips rows before returning results
  • LIMIT sets the maximum number of rows to return
  • Pagination is achieved by combining OFFSET and LIMIT

Ready to go further?

Start full exam Practice more questions

Related questions