The most commonly used SQL command is SELECT statement. The SQL SELECT statement is used to query or retrieve data from a table in the database. A query may retrieve information from specified columns or from all of the columns in the table. To create a simple SQL SELECT Statement, you must specify the column(s) name and the table name. The whole query is called SQL SELECT Statement.
SELECT column_list FROM table-name
[GROUP BY clause]
[ORDER BY clause];
- table-name is the name of the table from which the information is retrieved.
- column_list includes one or more columns from which data is retrieved.
- The code within the brackets is optional.