There is a table which shows bonus received by each employee within department. What would be the best way to get the second employee who received maximum bonus within department??
For department Receiving: it's John White... 700
For department Orders; it's Chris Abcd...200
The *.Xls (showing the content of the table ) is attached.