Jump to content

Data query language

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Z Doc (talk | contribs) at 13:17, 28 March 2020 (Restored basic explanation of the base concept of DQL as part of the SQL grouping. Needs assistance and additional work.). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Data Query Language (DQL) is part of the base grouping of SQL sub-languages. These sub-languages are mainly categorized into four categories, DDL, DQL, DML and DCL. Sometimes 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.

Statements

Related languages