• 2022-07-28
    职工表中有字符型字段“职工号”,用SQL DELETE命令将以字母H开头的职工记录删除,正确的命令是( )。
    A: DELETE FOR 职工号 LIKE “H%”
    B: DELETE WHILE 职工号 LIKE ”H%”
    C: DELETE WHERE 职工号=”H*”
    D: DELETE FROM 职工表 WHERE 职工号 LIKE “H%”
  • 举一反三