试题详情

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

Aselect ename,hiredate from emp where ename = ‘FORD‘;

Bselect ename,hiredate from emp where hiredate > (select hiredate from emp where ename = ‘FORD‘);

Cselect ename,hiredate from emp where hiredate > min(hiredate) and ename = ‘FORD‘;

Dselect ename,hiredate from emp where hiredate in (select hiredate from emp where ename = ‘FORD‘);