Misplaced Pages

Data query language

Article snapshot taken from[REDACTED] with creative commons attribution-sharealike license. Give it a read and then ask your questions in the chat. We can research this topic together.
Syntax used to query databases Not to be confused with Query language.

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 (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 language types

References

  1. "SQL Commands: DDL, DQL, DML, DCL and TCL With Examples". GeeksforGeeks. 2017-11-06. Retrieved 2024-08-22.
Database
Main
Languages
Security
Design
Programming
Management
Lists of
See also
WikiProject Category
Database management systems
Types
Concepts
Objects
Components
Functions
Related topics
Categories:
Data query language Add topic