emp表中,比“FORD”入职晚的员工信息,下列SQL语句正确的是:()

分类: 公共试题 发布时间: 2023-12-01 12:13 浏览量: 0

emp表中,比“FORD”入职晚的员工信息,下列SQL语句正确的是:()

A.selectename,hiredatefromemp =whereename='FORD';

B.selectename,hiredatefromemp =wherehiredate> =(selecthiredatefromemp =whereename='FORD');

C.selectename,hiredatefromemp =wherehiredate>min(hiredate) =andename='FORD';

D.selectename,hiredatefromemp =wherehiredatein =(selecthiredatefromemp =whereename='FORD');

正确答案是B