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