SQL statement | Description |
SELECT [Last Name], [First Name] | Selects the Last Name and First Name fields of each record in which the last name is King. |
SELECT [Last Name], [First Name] | Selects the Last Name and First Name fields for employees whose last names begin with the letter S. |
SELECT [Last Name], Salary | Selects employees whose salaries are between $20,000 and $30,000, inclusive. |
SELECT [Last Name], Salary | Selects employees whose last names fall in alphabetical order between Lon and Tol, inclusive. It doesn't retrieve Tolstoy because Tolstoy follows Tol and therefore is outside the specified range. |
SELECT [Order ID], [Order Date] | Selects orders placed during the first half of 1994. |
SELECT [Last Name], [First Name], City | Selects employees who live in Interlaken, New York, or Frankfurt. |
SELECT Title, [Year Published], Author | Selects title, year, and author for all titles that start with the letter "A" |