Data Manipulation

SQL statements used to add, modify or delete data in a database are referred to as data manipulation language (DML) commands. The items listed below describe in further detail the DML commands available in the MonetDB suite.

• Table Expressions

• GROUP BY Clause

• SAMPLE Clause

• Subqueries

• Table Updates

• MERGE Statement

• ANALYZE Statement

• PREPARE Statement

• SET Statement

• Window Functions