在表结构为(职工号 C,姓名 C,工资 N)的表Employee中查询职工号的为“1962”的最高工资值,正确的SQL命令是____________
A.
SELECT MAX(工资) FROM Employee WHILE LEFT(职工号,4)="1962"
B.
SELECT MAX(工资) FROM Employee WHERE LEFT(职工号,4)="1962"
C.
SELECT MIN(工资) FROM Employee WHILE LEFT(职工号,4)="1962"
D.
SELECT MAX(工资) FROM Employee WHERE RIGHT(职工号,4)="1962"