Learning Objectives:

  • Use the SQL Select statement to retrieve all data in a table
  • Specify a specific column list in a Select statement
  • Sort the results of a Select statement by one or more columns in ascending or descending order
  • Use one or more conditions in a where clause to limit the rows included in the results of a Select statement
  • Identify and properly use conditional operators in Select statements
  • Properly use AND and OR operators to express multiple conditions in a Select statement
  • Use aggregate functions in Select statements
  • Use the group by clause to limit the results of queries involving aggregate functions
  • Using the having clause to limit the results of queries involving aggregate functions
  • Properly use Distinct in a Select statement
  • Create join conditions for Select statements that involve multiple tables
  • Use column and table name aliases

Related Videos: