How to show second highest salary from a table

Answer 1

SELECT salary FROM ( SELECT ROW_NUMBER() OVER (ORDER BY salary DESC) AS rownumber, columns FROM tablename ) AS foo WHERE rownumber == 2

Answer 2

how to get parent category name in the same table by.parent id in laravel 5.4

Answer 3

how to get parent category name in the same table by.parent id in laravel 5.4