MySQL 5.0 Certification Study Guide

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