SELECT Statement: the FROM
In the previous outcome you used the basic format of the SELECT command, i.e.
This selected all the data from all the columns from each data row.
FROM employee; -- select all the employee details
FROM student; -- select all the student details
This is useful if you want a report on the full data content of a table. However, often you are only interested in specific columns and/or rows.
Selecting specific columns is possible by using the following syntax of the SQL SELECT command:
SELECT column, column, ....
SELECT employee_number, forename, surname, salary
Note: The selected columns do not have to be in the same order as defined in the table.