This statement is used to select data from a database and the data returned is stored in a result table, called the result-set.
The following are the two ways of using this statement:
SELECT column1, column2, ...
--(*) is used to select all from the table
SELECT * FROM table_name;