postgresql returning * limit code example

Example 1: postgresql limit

SELECT select_list
    FROM table_expression
    LIMIT number OFFSET number

Example 2: postgres limit

SELECT expressionsFROM tables[WHERE conditions][ORDER BY expression [ ASC | DESC ]]LIMIT row_count;