Try using parenthesis to enforce the order of execution.
select empno
from employee
where employed_date < ( sysdate - 60 );
Hope this helps.
AD
|
Results 1 to 3 of 3
Thread: SQL problemThreaded View
|
Click Here to Expand Forum to Full Width |