Select the names and the prices of all the products in the store.
| SELECT name FROM products
10 rows 0 msec
10 rows 0 msec
| name |
|---|
| Hard drive |
| Memory |
| ZIP drive |
| Floppy disk |
| Monitor |
| DVD drive |
| CD drive |
| Printer |
| Toner cartridge |
| DVD burner |
For all exercises, we will add the VERBOSE statement so that you can see the source.
The products data is on the page with the name "Products data". We put all tuples for convenience (query allows mutliple tuples in a page), but you could also make a page for each tuple. The FROM clause restricts the query to all pages that start with 'products'