This content has been marked as final. Show 2 replies
You can do what you want using a join and aggregate the DEPT table before the join.
How do we join here, there will be only value coming from Dept table that would be max(deptno). then we need filter the emp table based on this value.