The Computer Store exercise 13

Back to The Computer Store

Select the name and price of the cheapest product.

| VERBOSE
| SELECT name, price FROM products
| COPY
| GROUP price MIN
| RENAME price-min price
| JOIN price
1 row 0 msec
name price
Floppy disk 5