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

分类: 2019年公共题-数据库 发布时间: 2023-12-01 12:13 浏览量: 1

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

A.select ename,hiredate from emp where ename = 'FORD';

B.select ename,hiredate from emp where hiredate > (select hiredate from emp where ename = 'FORD');

C.select ename,hiredate from emp where hiredate > min(hiredate) and ename = 'FORD';

D.select ename,hiredate from emp where hiredate in (select hiredate from emp where ename = 'FORD');

正确答案是B