Data manipulation language
Data manipulation language (DML) describes the portion of SQL that manipulates or controls data.
- Retrieving data using the SELECT statement
The SELECT statement tailors your query to gather data. You can use the SELECT statement to retrieve a specific row or retrieve data in a specific way. - Inserting rows using the INSERT statement
To add a single row or multiple rows to a table or view, use a form of the INSERT statement. - Changing data in a table using the UPDATE statement
To update data in a table or view, use the UPDATE statement. - Removing rows from a table using the DELETE statement
To remove rows from a table, use the DELETE statement. - Merging data
Use the MERGE statement to conditionally insert, update, or delete rows in a table or view. - Using subqueries
You can use subqueries in a search condition as another way to select data. Subqueries can be used anywhere an expression can be used.
Parent topic: SQL programming
Related concepts: