MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `tempSalary` (
  `employeeSalaryId` int NOT NULL DEFAULT '0',
  `employeeId` int NOT NULL,
  `totalSalary` varchar(6) NOT NULL DEFAULT '',
  `value` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `currency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'AED',
  `effectiveFrom` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 INSERT INTO  `tempSalary`
(`employeeSalaryId`,
`employeeId`,
`totalSalary`,
`currency`,
`effectiveFrom`)
VALUES
(1 ,
 1000,
 19000,
 'USD',
 '2020-09-23');
INSERT INTO  `tempSalary`
(`employeeSalaryId`,
`employeeId`,
`totalSalary`,
`currency`,
`effectiveFrom`)
VALUES
(4 ,
 1000,
 22750,
 'USD',
 '2021-01-01');
SELECT 
    `es`.`employeeSalaryId`,
    `es`.`employeeId`,
    `es`.`totalSalary`,
    `es`.`currency`,
    `es`.effectiveFrom
FROM
    `tempSalary` `es`
WHERE
    `es`.`employeeId` = 1000
;


employeeSalaryId
employeeId
totalSalary
currency
effectiveFrom


1
1000
19000
USD
2020-09-23

4
1000
22750
USD
2021-01-01