🍋 ⚾️ 💻 🎬 🎮

coding_test/SQL 문제

[LeetCode] 1378. Replace Employee ID With The Unique Identifier (JOIN)

aeightchill 2025. 2. 7. 22:31
728x90

< 문제 >

[SQL50] 1378. Replace Employee ID With The Unique Identifier (JOIN)



< 풀이 >

SELECT B.unique_id, A.name
FROM Employees A LEFT JOIN EmployeeUNI B
    ON A.id = B.id;
728x90