Select One Column

What if you don't want to select all columns from a table? No problem. Just type the column name instead of the asterisk. If you want to get names of all users, type:

Syntax

SELECT column_name FROM table_name;


Execute below code to get the brand column from car table.

SELECT brand FROM car;

BRAND

Ford

Ford

Toyota

Volkswagen

Volkswagen

Volkswagen

Fiat

Opel