Select

MySQL Statement: Select

Categories:

Tags:

Limit Query

SELECT
    select_list
FROM
    table_name
LIMIT [offset,] row_count;

SELECT
    select_list
FROM
    table_name
LIMIT row_count OFFSET offset_count;

Using MySQL LIMIT to get the nth highest or lowest value

SELECT
  select_list
FROM
  table_name
ORDER BY
  sort_expression
LIMIT n-1, 1;

Reference