我有以下用例:
表Employee有3列-EmpID、OfficeMobile HomeMobile .
有些员工在两个地方给出了相同的数字。其他人给出了不同的答案。输出应为2列EmpID &ContactNo
如果两个位置的数字相同,则为1行,否则为2行。
EmpID | OfficeMobile | homobile | 1 | 123 | 123 | 2
---|---|---|
456 | 789 |
可以使用UNION ALL
SELECT ed.empId, ed.home_number as contact
FROM employeeDetails ed
UNION ALL
SELECT ed.empId, ed.mobile_number as contact
FROM employeeDetails ed
WHERE ed.home_number <> ed.mobile_number