Sql Select Examples

Select the names of all the products in the store.

Select the names and the prices of all the products in the store.

Select the name of the products with a price less than or equal to $200.

Select all the products with a price between $60 and $120.

Select the name and price in cents (i.e., the price must be multiplied by 100).

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-Share Alike 2.5 License.