PostgreSQL Select Data
Select Data
To retrieve data from a data base, we use the
SELECT
statement.
Specify Columns
By specifying the column names, we can choose which columns to select:
Return ALL Columns
Specify a *
instead of the column names to select all columns:
Exercise?What is this?
Test your skills by answering a few questions about the topics of this page
Drag and drop the missing code to select 'brand' from the 'cars' table.
;
FROM
cars
TABLE
SELECT
brand
CREATE
AS
INTO