SQL SELECT Database

SQL SELECT Database

SQL select statement is used to query or retrieve data from a table in the database. It is the most commonly used statement in SQL command.

If you want to retrieve information from specified column or all columns from a table, use SQL SELECT query.

The basic syntax of SQL SELECT statement is given below:

1. SELECT column_list FROM table_name  
2. [WHERE Clause]  
3. [GROUP BY Clause]  
4. [HAVING Clause]  
5. [ORDER BY Clause];  

The example of select statement is given below:

1. SELECT firstname,lastname,salary FROM employee;