[{with}] delete from {table name} [where {expr}]

delete from demo where id = 1

DELETE [LOW_PRIORITY] [QUICK] [IGNORE]

    FROM tbl_name [PARTITION (partition_list)]

    [WHERE where_condition]

    [ORDER BY ...]

    [LIMIT row_count]

    [RETURNING select_expr

      [, select_expr ...]]

DELETE [LOW_PRIORITY] [QUICK] [IGNORE]

    tbl_name[.*] [, tbl_name[.*]] ...

    FROM table_references

    [WHERE where_condition]

DELETE [LOW_PRIORITY] [QUICK] [IGNORE]

    FROM tbl_name[.*] [, tbl_name[.*]] ...

    USING table_references

    [WHERE where_condition]

DELETE HISTORY

  FROM tbl_name [PARTITION (partition_list)]

  [BEFORE SYSTEM_TIME [TIMESTAMP|TRANSACTION] expression]

[ WITH [ RECURSIVE ] with_query [, ...] ]

DELETE FROM [ ONLY ] table_name [ * ] [ [ AS ] alias ]

    [ USING using_list ]

    [ WHERE condition | WHERE CURRENT OF cursor_name ]

    [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]

-- Syntax for SQL Server and Azure SQL Database

[ WITH <common_table_expression> [ ,...n ] ]

DELETE

    [ TOP ( expression ) [ PERCENT ] ]

    [ FROM ]

    { { table_alias

      | <object>

      | rowset_function_limited

      [ WITH ( table_hint_limited [ ...n ] ) ] }

      | @table_variable

    [ <OUTPUT Clause> ]

    [ FROM table_source [ ,...n ] ]

    [ WHERE { <search_condition>

            | { [ CURRENT OF

                   { { [ GLOBAL ] cursor_name }

                       | cursor_variable_name

    [ OPTION ( <Query Hint> [ ,...n ] ) ]

[; ]

<object> ::=

    [ server_name.database_name.schema_name.

      | database_name. [ schema_name ] .

      | schema_name.

    table_or_view_name

-- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse

DELETE

    [ FROM [database_name . [ schema ] . | schema. ] table_name ]

    [ WHERE <search_condition> ]

    [ OPTION ( <query_options> [ ,...n ]  ) ]

[; ]