Add sub-query in where clause in extract

 Hi, I want to add "Sub-Query" in "Where" clause but not getting the expected result.

TABLE scott.emp,SQLEXEC (id deptno,  query 'select max(deptno) from scott.emp') ;

In above I want to to transfer only max detpno records but when I start extract all records transfer.

Please any one help me to resolve this query.

 Thank You & Regards

 Qasim