我需要显示部门1中所有比部门2中的雇员还年轻的ID,姓名和出生日期。我试图在没有加入的情况下进行处理。
这是我目前的情况,运行时它不会失败,但是它显示了部门2的所有工人,无论他们的生日如何。
SELECT ID, CONCAT(fName," " ,lName) AS "Worker Name", dob
FROM Worker
WHERE dob <= ALL (SELECT department
FROM Worker
WHERE deparment = 1
)
AND deparment = 2;
您要检查DOB,然后应选择DOB
SELECT ID, CONCAT(fName," " ,lName) AS "Worker Name", dob
FROM Worker
WHERE dob <= ALL (SELECT dob
FROM Worker
WHERE deparment = 1
)
AND deparment = 2;
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句