alternative for limit in sql

Solutions on MaxInterview for alternative for limit in sql by the best coders in the world

showing results for - "alternative for limit in sql"
Estelle
28 Oct 2020
1
2 SELECT TOP 3 * FROM Customers;
3 
Sara
16 Jun 2019
1SELECT
2    product_name,
3    list_price
4FROM
5    production.products
6ORDER BY
7    list_price DESC,
8    product_name 
9OFFSET 0 ROWS 
10FETCH FIRST 10 ROWS ONLY;
11Code language: SQL (Structured Query Language) (sql)