SQL > SQL Commands >
The SELECT statement in SQL is used to retrieve data from a relational database.
"table_name" is the name of the table where data is stored, and "column_name" is the name of the column containing the data to be retrieved.
To select more than one column, add a comma to the name of the previous column, and then add the column name. If you are selecting three columns, the syntax will be,
SELECT "column_name1", "column_name2", "column_name3" FROM "table_name";
Note there is no comma after the last column selected.
We will provide examples for each of the following three use cases:
Let's use the following table to illustrate all three cases:
Example 1: Select one column
To select a single column, we specify the column name between SELECT and FROM as follows:
SELECT Store_Name FROM Store_Information;
Example 2: Select multiple columns
We can use the SELECT statement to retrieve more than one column. To select Store_Name and Sales columns from Store_Information, we use the following SQL:
SELECT Store_Name, Sales FROM Store_Information;
Example 3: Select all columns
There are two ways to select all columns from a table. The first is to list the column name of each column. The second, and the easier, way is to use the symbol *. For example, to select all columns from Store_Information, we issue the following SQL:
SELECT * FROM Store_Information;
For these exercises, assume we have a table called Users with the following columns:
1. Which of the following SQL statement is incorrect? (There can be more than one answer)
2. (True Or False) In SQL, the order of the columns in a SELECT statement must be the same as the order of the columns in the underlying table. For example, in the table Users, you must select First_Name before Last_Name.
3. (True Or False) The following two SQL statements are equivalent: