Delete comment from: Javarevisited
SELECT *
FROM EMPLOYEES
ORDER BY SALARY DESC
OFFSET 1 ROWS
FETCH NEXT 1 ROW ONLY
Oct 23, 2019, 8:13:57 PM
Posted to How to find second highest or maximum salary of Employee in SQL - Interview question
Blogger
SELECT *
FROM EMPLOYEES
ORDER BY SALARY DESC
OFFSET 1 ROWS
FETCH NEXT 1 ROW ONLY
Oct 23, 2019, 8:13:57 PM
Posted to How to find second highest or maximum salary of Employee in SQL - Interview question