题目内容:
在表结构为(职工号,姓名,工资.的表Employee中查询职工号的第5位开始的4个字符为“0426”职工情况,正确的SQL命令是
A.SELECT*FROM Employee WHERE SUBSTR(职工号,4,5.=”0426” B.SELECT*FROM Employee WHERE STR(职工号,4,5.=”0426”
C.SELECT*FROM Employee WHERE STR(职工号,5,4.=”0426”
D.SELECrFROM Employee WHERE SUBSTR(职 工号,5,4.=”0426”
参考答案:
答案解析: