使用SQL语句将职工表中年龄＞60的职工记录删除，正确的命令是______。 A: DELETE FOR AGE＞60 B: DELETE 职工表 FOR(YEAR(DATE())-YEAR(出生日期))60 C: DELETE FROM 职工表 WHERE(YEAR(DATE())-YEAR(出生日期))＞60 D: DELETE 职工表 WHERE(YEAR(DATE())-YEAR(出生日期))＞60

公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！

2022-06-28

使用SQL语句将职工表中年龄＞60的职工记录删除，正确的命令是______。 A: DELETE FOR AGE＞60 B: DELETE 职工表 FOR(YEAR(DATE())-YEAR(出生日期))60 C: DELETE FROM 职工表 WHERE(YEAR(DATE())-YEAR(出生日期))＞60 D: DELETE 职工表 WHERE(YEAR(DATE())-YEAR(出生日期))＞60

使用SQL语句将职工表中年龄＞60的职工记录删除，正确的命令是______。
A: DELETE FOR AGE＞60
B: DELETE 职工表 FOR(YEAR(DATE())-YEAR(出生日期))60
C: DELETE FROM 职工表 WHERE(YEAR(DATE())-YEAR(出生日期))＞60
D: DELETE 职工表 WHERE(YEAR(DATE())-YEAR(出生日期))＞60

答案：

查看

举一反三