This chapter discusses how to use the SELECT statement to retrieve information from database tables. It covers the following exam topics:
Specifying which columns to retrieve and the table from which to retrieve them
Using WHERE to identify the characteristics that define which records to retrieve
Using ORDER BY to sort query results
Using LIMIT to limit the output to a specific number of the rows retrieved
Using DISTINCT to eliminate duplicates
Computing summary values from groups of rows
Using UNION to combine results from multiple queries into a single result set