psql offset code example

Example 1: offset in postgresql example

Syntax,



SELECT select_list

    FROM table_expression

    [ ORDER BY ... ]

    [ LIMIT { number | ALL } ] [ OFFSET number ]

Example 2: OFFSET consulta mysql

SELECCIONAR {nombre de campo (s) | *} FROM tableName (s) [WHERE condición] LIMIT N;