CODE EXAMPLE FOR SQL

alternative for LIMIT sql

SELECT
    product_name,
    list_price
FROM
    production.products
ORDER BY
    list_price DESC,
    product_name 
OFFSET 0 ROWS 
FETCH FIRST 10 ROWS ONLY;
Code language: SQL (Structured Query Language) (sql)