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
'coding_test > SQL 문제' 카테고리의 다른 글
[LeetCode] 1581. Customer Who Visited but Did Not Make Any Transactions (JOIN) (0) | 2025.02.07 |
---|---|
[LeetCode] 1068. Product Sales Analysis I (JOIN) (0) | 2025.02.07 |
[LeetCode] 1683. Invalid Tweets (SELECT) (0) | 2025.02.07 |
[LeetCode] 1148. Article Views I (SELECT) (0) | 2025.02.07 |
[LeetCode] 595. Big Countries (SELECT) (0) | 2025.02.07 |