Type: Posts; User: madhumnc; Keyword(s):
try 'MINUS' operation
Try this: Select Name, DeptNo, sal as maxsal from emp where sal=(select max(sal) from emp);