get Fifth highest paid employee details in sql | limit | offset
Get Fifth highest paid employee details in sql SELECT * FROM employee ORDER BY salary ASC LIMIT 1 OFFSET 5. ORDER BY salary ASC - by this we are arranging salary in Ascending order. LIMIT 1 - By this we are fetching only one employee details. OFFSET 5 - By this we are start fetching record from 5th number record.