Hi Guys, Please help me on how to get this one. e_id, e_name, e_job,e_sal,deptno 100,sam,clerck,2000,10 200,tom,salesman,1200,20 300,lin,driver,1600,20 400,tim,manager,2500,10 500,zim,pa,2200,10 600,eli,clerck,2300,20 Here our requirement is to find the maximum salary from each dept. number and diplay the whole records. expected o/p: e_id, e_name, e_job,e_sal,deptno 400,tim,manager,2500,10 600,eli,clerck,2300,20 I tried aggregator. but aggregator only returns the grouped column and the calculation column ( user defined) . ex: deptno, max(sal) 10 , 2500 20, 2300 But I need to get the entire record in my o/p. Thanks!!
Posted on: Tue, 22 Jul 2014 07:18:41 +0000
Trending Topics
Recently Viewed Topics
© 2015