Data Manipulation Language (DML)

In this page, we will explore the useful Data Manipulation Language (DML) commands such as Insert, Update along with examples.

Add Column

Aggregate Functions

ALL

AND

ANY

Approx_Count_Distinct

BETWEEN

CASE

CAST

CHARINDEX

COALESCE

Column & Table Aliases

Common Table Expressions (CTE)

Convert

Correlated Subquery

Count

CROSS APPLY

CROSS JOIN

  • A SQL join on multiple tables: overview and implementation
  • SQL CROSS JOIN with examples
  • CUBE

    DATEADD

    DATEDIFF

    DATEPART

    DELETE

    EXCEPT

    EXISTS

    FULL OUTER JOIN

    GROUP BY

    GROUPING SETS

    HAVING

    IF

    IN

    INNER JOIN

    INSERT

    INSERT INTO SELECT

    INSERT Multiple Rows

    INTERSECT

    ISNULL

    JOIN

    LEFT JOIN

    LIKE

    MERGE

    Not NULL

    NULL

    OFFSET FETCH

    OR

    ORDER BY

    OUTER Join

    PARTITION BY

    PIVOT

    Ranking Functions

    Recursive CTE

    Replace

    RIGHT JOIN

    ROLLUP

    ROW_NUMBER

    SELECT

    SELECT DISTINCT

    SELECT INTO

    SELECT TOP

    Self Join

    STRING_SPLIT

    Subquery

    Triggers

    TRIM

    TRY_Convert

    TRY_PARSE

    Union

    Union All

    UPDATE

    UPDATE JOIN

    Where


    SQLShack
    Latest posts by SQLShack (see all)