Question : alternative for LIMIT sql
Answered by : breakable-bug-57agftl2qebp
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)
Source : https://www.sqlservertutorial.net/sql-server-basics/sql-server-offset-fetch/ | Last Update : Tue, 24 Aug 21