Select the name and price of all products with a price larger than or equal to $180, and sort first by price (in descending order), and then by name (in ascending order).
| SELECT name, price FROM products WHERE price >= 180
| ORDER price NUMERIC DESC, name
5 rows 0 msec
| ORDER price NUMERIC DESC, name
5 rows 0 msec
| name | price |
|---|---|
| Printer | 270 |
| Hard drive | 240 |
| Monitor | 240 |
| DVD burner | 180 |
| DVD drive | 180 |
The ORDER statement can have NUMERIC and DESC qualifiers for the fields.