Grouping values in an attribute

[shayusuf (Shaikh Yusuf Niaz)]

how to find 2nd highest salary against each department for the table shown in the video