Advertisement
Guest User

Untitled

a guest
Apr 20th, 2014
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.20 KB | None | 0 0
  1. select order_id, order_descr
  2. from (select order_id, order_descr, row_number() over(order by order_date desc) r
  3. from orders
  4. where customer_id = 123)
  5. where r between 1 and 101
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement