下列语句中正确的是（）
A: DELETE < > [WHERE 筛选条件] [ORDER BY 子句] [LIMIT 子句]
B: DELETE [WHERE 筛选条件] [ORDER BY 子句] [LIMIT 子句]
C: DELETE [ORDER BY 子句]
D: DELETE FROM < > [WHERE 筛选条件] [ORDER BY 子句] [LIMIT 子句]
A: DELETE < > [WHERE 筛选条件] [ORDER BY 子句] [LIMIT 子句]
B: DELETE [WHERE 筛选条件] [ORDER BY 子句] [LIMIT 子句]
C: DELETE [ORDER BY 子句]
D: DELETE FROM < > [WHERE 筛选条件] [ORDER BY 子句] [LIMIT 子句]
举一反三
- 用来对查询结果进行排序的子句是（） A: WHERE子句 B: ORDER BY 子句 C: LIMIT子句 D: GROUP BY 子句
- select语句中的where子句和having子句都是条件子句,where子句是对记录进行筛选,而having子句则是对组进行筛选。
- SELECT语句中，对查询结果排序的子句是： A: FROM子句 B: WHERE子句 C: GROUP BY子句 D: ORDER BY子句
- 在查询语句的下列子句中，通常和HAVING子句同时使用的是（ ）。 A: WHERE子句 B: ORDER BY子句 C: GROUP BY子句 D: FROM子句
- 下列哪个子句在SELECT语句中用于排序结果集 A: HAVING子句 B: WHERE子句 C: FROM子句 D: ORDER BY子句