EmployeeBranchId = 1 has two entries which one do u want retain?
SELECT d.*,
(SELECT RAW MIN(eb)
FROM d.EmployeeBranch AS eb
GROUP BY eb.EmployeeBranchId) AS EmployeeBranch
FROM default AS d
WHERE ......;
EmployeeBranchId = 1 has two entries which one do u want retain?
SELECT d.*,
(SELECT RAW MIN(eb)
FROM d.EmployeeBranch AS eb
GROUP BY eb.EmployeeBranchId) AS EmployeeBranch
FROM default AS d
WHERE ......;