O'Reilly logo

MySQL 5.0 Certification Study Guide by Carsten Pedersen, Stefan Hinz, Paul DuBois

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

Image Specifying which columns to retrieve and the table from which to retrieve them

Image Using WHERE to identify the characteristics that define which records to retrieve

Image Using ORDER BY to sort query results

Using LIMIT to limit the output to a specific number of the rows retrieved

Using DISTINCT ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required