SQL SELECT Statement | DQL Command

The SQL SELECT Statement

The SELECT statement is used to select data from a database.

The data returned is stored in a result table, called the result-set.

SELECT Syntax

SELECT column1, column2, ...
FROM table_name;

Here, column1, column2, ... are the field names of the table you want to select data from. If you want to select all the fields available in the table, use the following syntax:

SELECT * FROM table_name;

SELECT Column Example

The following SQL statement selects the "CustomerName" and "City" columns from the "Customers" table:

Example

SELECT CustomerName, City FROM Customers;

SELECT * Example

The following SQL statement selects all the columns from the "Customers" table:

Example

SELECT * FROM Customers;

Credit : w3schools

SELECT Command In SQL| DQL Command

SELECT Command

SELECT command is one type of DQL (Data Query Language) command, which used to find information from one or more tables, and return the query as a Result Set.

Definition of Result Set :

When we are using select query its retrieve data or values in a result table, called the result-set.
Syntax :

1) SELECT column_name1, column_name2 FROM table_name ;

2) SELECT * FROM table_name ;

Select command has two types of parameters :

1) column_name - This parameter specifies the name of column, which data we want to retrieve.
2) table_name - This parameter specifies the name of table.

Example:

// Select Customer City and Address from Customer01 table

SELECT C_City, C_Address FROM Customer01;

// Select all data from table

SELECT * FROM Customer01 ;

* * * * * * * * * * * * * * * * * 

In Easy Language :

Select command used to retrieve data or values from database .