Hi I'm new to Teradata, can you please let me how to achive this requirement
I have to assign rank to employee who performed well in all departments. Each employee has 3 departments (A,B,C) and the business they did for the orginazation
Employee name, Dept Name, Amount
out of 3 employees, #3 did good business of $60, next #1 then #2
so, I have assign ranks like below
Employee name, Dept Name, Amount, Rank
Please help me how to achive this?