Innovaccer interview question

Window function related question Second highest salary