offset and limit in sql

PHOTO EMBED

Sun Apr 24 2022 01:43:40 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

---select rank 2,3 user that generates the most sales
select customer_id, sum(sales) as total
from orders_tab as ot 
group by customer_id 
order by total desc
offset 1 limit 2 -- skip row 1 and limit by 2
content_copyCOPY