Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 fields emp_name and salary...I need to add third Field called as Rank which should have data based on the salary of Employees..like
emp_name salary rank
Jim 60000 2
Peter 50000 3
Ram 70000 1
Can Anyone Help?
use rank function in load statement rank( col1)
Hi,
Try this way.
load
RowNo() as Rank,
emp_name as E_N,
sum(salary) as Sal
resident Data Group by emp_name order by salary desc;
Regards,
Kaushik Solanki