Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
Chapter 2. Retrieving Information from D... > Performing Single Table SELECT State...
Performing Single Table SELECT Statements
The SELECT statement is used to retrieve information from tables in the database. In its simplest form, you specify the table from which you want to retrieve data, and specify a list of column names to retrieve. The SELECT statement in the following example retrieves the customer_id, first_name, last_name, dob, and phone columns from the customers table:
SELECT customer_id, first_name, last_name, dob, phone FROM customers;
