Chapter 9. Querying for Data


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



MySQL 5 Certification Study Guide
MySQL 5.0 Certification Study Guide
ISBN: 0672328127
EAN: 2147483647
Year: 2006
Pages: 312

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net