SQL SELECT Statement

The SQL SELECT statement is used to select data from a database, and the data returned is stored in a result table, called the result-set.

• The SELECT statement retrieves data from a database.
• The data is returned in a table-like structure called a result-set.
• SELECT is the most frequently used action on a database.

Syntax of SQL SELECT Statement

SELECT column_list FROM table_name;

SELECT * FROM table_name;

A query may retrieve information from specified columns or from all of the columns in the table. To create a simple SQL SELECT Statement, you must specify the column(s) name and the table name.

Employee Table

A sample of EMPLOYEE records table & the name of table Employee. The column(s) of the Employee table [ID, EMPLOYEE_NAME, EMPLOYEE_EMAIL, ADDRESS, CITY, and COUNTRY]:

Select Query with Multiple Column

In this SELECT statement, we SELECT three column - Address, City and Country. How to look table ofter using query, it mentioned below:

SELECT Address, City, Country FROM Employee

Result