Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select order_id, order_descr
- from (select order_id, order_descr, row_number() over(order by order_date desc) r
- from orders
- where customer_id = 123)
- where r between 1 and 101
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement