selecting rows
In order to extract data from the database you need to use the Structured Query
Language (SQL) SELECT command. You may need to restrict the columns that
are displayed. This lesson explains all of the commands you will use to perform
these actions.
You will want to create SELECT statements that can be used time and time
again. In this lesson you will also see how to save your statements for later use.
At the end of this lesson, you should be able to
Write a SELECT statement to query the database.
Perform arithmetic calculations using SQL arithmetic operators.
Handle null values.
Specify alternative column headings...