We will be using below Students table to explain the

Example Queries:-

If there are a large number of tuples satisfying the query conditions, it might be
resourceful to view only a handful of them at a time.

• The LIMIT clause is used to set an upper limit on the number of tuples
  returned by SQL.
• It is important to note that this clause is not supported by all SQL versions.
• The LIMIT clause can also be specfied using the SQL 2008 OFFSET/FETCH
  FIRST clauses.
• The limit/offset expressions must be a non-negative integer.

Example Queries to demonstrate LIMIT Clause.

• SELECT *
  FROM Students
  LIMIT 3;

Output of the query gives First three Student Records.

• SELECT *
  FROM Students
  ORDER BY age
  LIMIT 3;

Output of the query gives three Student Records in order of Ascending Ages.

The LIMIT operator can be used in situations such as the above, where we need to
find the top N students in a class and based on any condition statements.

Using LIMIT along with OFFSET

LIMIT x OFFSET y simply means skip the first y entries and then return the next x
entries.
OFFSET can only be used with the ORDER BY clause. It cannot be used on its own.
OFFSET value must be greater than or equal to zero. It cannot be negative, else
returns error.
Example query to demonstrate LIMIT and OFFSET.

• SELECT *
  FROM Students
  LIMIT 3 OFFSET 2
  ORDER BY roll_no;

Returns 3 Student Records skipping first two records in Table.