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

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