SELECT

SELECT statement is used to access records from a database. The table which stores the record returned by the SELECT statement is called a result-set table.

Syntax-

SELECT column_name1, column_name2, …column_nameN

FROM <table_name>;

Description-

The column_name1, column_name2, …column_nameN are the name of those columns in the table whose data we want to read or access.

Syntax-

SELECT *

FROM <table_name>;

Description-

To access all records from given table, use the above SQL SELECT syntax with * asterisk sign.