title: "Queries | Microsoft Docs" ms.custom: "" ms.date: "03/16/2017" ms.prod: sql ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.reviewer: "" ms.suite: "sql" ms.technology: t-sql ms.tgt_pltfrm: "" ms.topic: "language-reference" dev_langs:
- "TSQL" ms.assetid: 5ff02a32-e8d3-479c-ae8b-07581e41f5f8 caps.latest.revision: 8 author: "douglaslMS" ms.author: "douglasl" manager: craigg monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017"
[!INCLUDEtsql-appliesto-ss2008-all_md]
Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in [!INCLUDEssCurrent] and SQL Database. Most also work in SQL Data Warehouse and PDW (review each individual statement for details). Use these statements to add, modify, query, or remove data from a [!INCLUDEssNoVersion] database.
The following table lists the DML statements that [!INCLUDEssNoVersion] uses.
The following table lists the clauses that are used in multiple DML statements or clauses.
| Clause | Can be used in these statements |
|---|---|
| FROM (Transact-SQL) | DELETE, SELECT, UPDATE |
| Hints (Transact-SQL) | DELETE, INSERT, SELECT, UPDATE |
| OPTION Clause (Transact-SQL) | DELETE, SELECT, UPDATE |
| OUTPUT Clause (Transact-SQL) | DELETE, INSERT, MERGE, UPDATE |
| Search Condition (Transact-SQL) | DELETE, MERGE, SELECT, UPDATE |
| Table Value Constructor (Transact-SQL) | FROM, INSERT, MERGE |
| TOP (Transact-SQL) | DELETE, INSERT, MERGE, SELECT, UPDATE |
| WHERE (Transact-SQL) | DELETE, SELECT, UPDATE, MATCH |
| WITH common_table_expression (Transact-SQL) | DELETE, INSERT, MERGE, SELECT, UPDATE |