SQL SELECT

In this Tutorial, we will learn how to select records from a table using SQL.

SQL SELECT Statement

The most commonly used SQL Statement is SELECT statement.

The SELECT Statement is used to fetch/retrieve or select the data from the database. The data is returned in a table like structure known as result-set.

SELECT column1,column2...columnN
FROM tableName

Here "column1,column2..." are the fields of a tablewhose value you want to retrieve or fetch and "tableName" is the name of the table where data is stored.

SELECT *
FROM tableName

SELECT column1,column2...columnN
FROM tableName

Example:

Let us consider this table "Employee" for records.

Table Name: Employee

Here are some examples of SELECT statement:

SELECT EmpName FROM Employee

SELECT ID,EmpName,City 
FROM Employee;

SELECT * FROM Employee