Select Statement

The SELECT statement is used to retrieve the rows from one or more tables in a database.

Selecting All Columns

To select all the rows of a table, use the asterisk (*).

Syntax

SELECT <query-parameters> FROM <table-name>;

Example #1

SELECT * FROM Companies;

Tip: If you have a lot of rows use ctrl-c or cmd-c to escape from viewing more rows.

Selecting Specific Columns

Specific columns can be retrieved from a table too.

Syntax

SELECT <column-name> FROM <table-name>;

Example #2

SELECT name, founded, hq FROM Companies;