DQL Command | Data Query Language | SQL Command

DQL Command

DQL command is used to retrieve data from database.

DQL command has one type :

• SELECT

SELECT Command

SELECT command is used to find information from one or more tables, and return the query as a result set.

Syntax :

1) SELECT * FROM table_name;
2) SELECT column_name1, column_name2 FROM table_name;

Using with * sign we can retrieve all data from database.
Also we can select particular data from database.

Example :

1) SELECT * FROM Customer01;
2) SELECT C_Id, C_FirstName FROM Cutomer01;

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

In Easy Language

Select command used to retrieve data from database.