Lesson 2. Retrieving Data

In this lesson, you’ll learn how to use the all-important SELECT statement to retrieve one or more columns of data from a table.

The SELECT Statement

As explained in Lesson 1, “Understanding SQL,” SQL statements are made up of plain English terms. These terms are called keywords, and every SQL statement is made up of one or more keywords. The SQL statement that you’ll probably use most frequently is the SELECT statement. Its purpose is to retrieve information from one or more tables.

New Term: Keyword

A reserved word that is part of the SQL language. Never name a table or column using a keyword. Appendix D, “SQL Reserved Words,” lists some of the more common reserved words.

To use SELECT to retrieve table data, you ...

Get Sams Teach Yourself SQL in 10 Minutes a Day, 5th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.