Select from Table

A common use is to select data from the tables located in a database. Immediately, we see two keywords: we need to SELECT information FROM a table.

Syntax

SELECT "column_name" FROM "table_name"

Example

SELECT store_name FROM Store_Information
Result:
store_name
Los Angeles
San Diego
Los Angeles
Boston