educative.io

Educative

Using limit offset option without having a nested select

The solution proposed used a nested select, why not using the limit offset like this?

SELECT Salary as SECOND_HIGHEST from SALARY order by salary desc limit 1 offset 1;

Yeah, we can use the offset method also to solve this database problem because there might be multiple methods to solve a problem.