Find 2 highest salary from each depart who have completed 5 years in org.

I have to find 2 highest salary from each depart, and employee should have tenure more then 5 years. Table has emp id, name, salary, depart, DOJ. Tried but getting only for 1 depart not for all and no idea about the timestamp, how to subtract to see the tenure.. please advise new in hive still studying for future (: Thanks


This Question is not yet answered!


Related Answered Questions


Related Open Questions