By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE service(
id INT,
position varchar(10),
experience int,
salary int );
insert into service values
(1,'top',90,1500),
(2,'bottom',100,1500),
(3,'top',90,750),
(4,'left',90,1000),
(5,'right',100,1300),
(6,'top',90,1500),
(7,'left',80,2000),
(8,'top',80,1000),
(9,'bottom',100,2000),
(10,'left',100,2000);
Records: 10 Duplicates: 0 Warnings: 0
SELECT s.*,s1.*
FROM service s
LEFT JOIN (select max(experience) as max_experience
from service
) as s1 ON s.experience = s1.max_experience ;
| id | position | experience | salary | max_experience |
|---|---|---|---|---|
| 1 | top | 90 | 1500 | null |
| 2 | bottom | 100 | 1500 | 100 |
| 3 | top | 90 | 750 | null |
| 4 | left | 90 | 1000 | null |
| 5 | right | 100 | 1300 | 100 |
| 6 | top | 90 | 1500 | null |
| 7 | left | 80 | 2000 | null |
| 8 | top | 80 | 1000 | null |
| 9 | bottom | 100 | 2000 | 100 |
| 10 | left | 100 | 2000 | 100 |