728x90
https://leetcode.com/problems/replace-employee-id-with-the-unique-identifier/
SELECT u.unique_id, e.name
FROM Employees AS e
LEFT JOIN EmployeeUNI AS u ON e.id = u.id;
728x90
'IT > 코딩테스트' 카테고리의 다른 글
[Leetcode] 1068. Product Sales Analysis I (0) | 2023.08.24 |
---|---|
[Leetcode] 283. Move Zeroes (0) | 2023.08.23 |
[Leetcode] 595. Big Countries (0) | 2023.08.22 |
[Leetcode] 584. Find Customer Referee (0) | 2023.08.22 |
[Leetcode] 1757. Recyclable and Low Fat Products (0) | 2023.08.21 |