By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Employee (salary DECIMAL(10,2))
INSERT INTO Employee VALUES(10000.1)
select salary
from Employee
order by salary desc
limit 1,2
INSERT INTO Employee VALUES(20000.2)
select salary
from Employee
order by salary desc
limit 1,2
| salary |
|---|
| 10000.10 |