Select Many Column

Great! If you want to get a couple of columns, give the names of the interesting columns before FROM. So to get names and ages of all users, type:

Syntax

 
SELECT column_name1,column_name1,... FROM table_name;

Note that you separate the names of the columns with a comma (,).


Execute below code to get the result

SELECT brand,model,price FROM car;

 Result

BRAND	MODEL	PRICE
Ford	Focus	8000.00
Ford	Fusion	12500.00
Toyota	Avensis	11300.00
Volkswagen	Golf	3270.00
Volkswagen	Golf	13000.00
Volkswagen	Jetta	6420.00