Which two keywords cannot be used in multi-table deletes?

The correct answer is B. ORDER BY C. LIMIT. You can specify multiple tables in a DELETE statement to delete rows from one or more tables depending on the particular condition in the WHERE clause. However, you cannot use ORDER BY or LIMIT in a multiple-table DELETE.

SQL Data Manipulation

Question

Options

AUSING
BORDER BY
CLIMIT
DIGNORE
EJOIN

How the community answered

(25 responses)

A
4% (1)
B
84% (21)
D
4% (1)
E
8% (2)

Explanation

You can specify multiple tables in a DELETE statement to delete rows from one or more tables depending on the particular condition in the WHERE clause. However, you cannot use ORDER BY or LIMIT in a multiple-table DELETE.

Topics

#multi-table DELETE#ORDER BY restriction#LIMIT restriction#DML syntax

Community Discussion

No community discussion yet for this question.

Full 1Z0-882 Practice