/* ---------------------------------------------------------------- This script shows how to write simple SELECT queries to retrieve data from a table GENERAL QUERY SYNTAX: -------------------------- SELECT what_to_select FROM which_table [WHERE conditions_to_satisfy] [ORDER BY what_to_sort]; ---------------------------------------------------------------- */ /* Example: Select all customers */ SELECT * FROM Customers; /* Example: select only Company and Contact names from the Customers table */ SELECT CompanyName, ContactName FROM Customers ORDER BY ContactName; /* Example: Select only Customers whose names begin with Christina */ SELECT ContactName FROM Customers WHERE ContactName LIKE 'Christina%';