Data Query Language (DQL) is part of the base grouping of
SQL sub-languages. These sub-languages are mainly categorized into four categories: a data query language (DQL), a
data definition language (DDL), a
data control language (DCL), and a
data manipulation language
A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database. A DML is often a sublanguage of a broader database language such as SQL, with the DML compr ...
(DML). Sometimes a transaction control language (TCL) is argued to be part of the sub-language set as well.
DQL statements are used for performing queries on the data within schema objects. The purpose of DQL commands is to get the schema relation based on the query passed to it.
Although often considered part of DML, the SQL
SELECT statement is strictly speaking an example of DQL. When adding FROM or WHERE data manipulators to the SELECT statement the statement is then considered part of the DML.
Related languages
*
Data definition language
*
Data manipulation language
A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database. A DML is often a sublanguage of a broader database language such as SQL, with the DML compr ...
*
Data control language
*
Transactional Control Language
Transaction or transactional may refer to:
Commerce
*Financial transaction, an agreement, communication, or movement carried out between a buyer and a seller to exchange an asset for payment
*Debits and credits in a Double-entry bookkeeping syst ...
{{databases
Data modeling
SQL