Listing Columns to Retrieve with SELECT

Go Up to Understanding Data Retrieval with SELECT

A list of columns to retrieve must always follow the SELECT keyword in a SELECT statement. The SELECT keyword and its column list is called a SELECT clause.

Topics

• Retrieving a List of Columns
• Retrieving All Columns
• Eliminating Duplicate Columns with DISTINCT
• Retrieving Aggregate Column Information
• Multi-table SELECT Statements