Selecting Specific Columns

Command :

SELECT dept_name, location, FROM dept;

Note :

Select particular columns from the dept table.

Example Table :

Emp_name	Emp_id	Location	Dept_Name	Salary
Arun	101	Salem	Accounts	12000
Balu	109	Chennai	Purchase	15000
Ramesh	200	Salem	Admin	13000
Saravanan	150	Coimbatore	Sales	14500
Velu	333	Trichy	Production	10500
Gopi	104	Salem	Marketing	15000
Prabu	108	Salem	IT	12500

Out put :

Dept_Name	Location
Accounts	Salem
Purchase	Chennai
Admin	Salem
Sales	Coimbatore
Production	Trichy
Marketing	Salem
IT	Salem