6.8 slide #36
/* slide#36 ORDER BY for Sorting rows */
SELECT *
FROM ORDER_ITEM
ORDER BY OrderNumber
;
OrderNumber | SKU | Quantity | Price | ExtendedPrice |
---|---|---|---|---|
1000 | 201000 | 1 | 300 | 300 |
1000 | 202000 | 1 | 130 | 130 |
2000 | 101100 | 4 | 50 | 200 |
2000 | 101200 | 2 | 50 | 100 |
3000 | 100200 | 1 | 300 | 300 |
3000 | 101100 | 2 | 50 | 100 |
3000 | 101200 | 1 | 50 | 50 |