SQL Select Command

SQL Select Command

Select command is used to retrieved the data from the existing table in the database.

• Using Select command you can retrieve all the records from the table in the database.
• Using Select command you can retrieve specific records from the table "using where clause"

	
select * from table_name;

Note: In the above syntax * represent all columns.

	
select * from Employee;

Employee table

Using this table i will show you how to select employee record whose salary is greater than 30000.

SELECT emp_id, name FROM Employee

Result after using Select Command

Select command with where clause

When you need to select some specific record from table you can use where clause with select command, in below example i will select those employee records who have more than 30000 salary.

SELECT * from Employee
WHERE salary>30000;

Result after using Execute above query.