SQL/LeetCode

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

yeyeyep 2025. 2. 20. 18:47

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT eu.unique_id
    , e.name
FROM Employees AS e
    LEFT JOIN EmployeeUNI AS eu ON e.id = eu.id

 

 

'SQL > LeetCode' 카테고리의 다른 글

[LeetCode] 1407. Top Travellers  (0) 2025.02.20
[LeetCode] 1393. Capital Gain/Loss  (0) 2025.02.20
[LeetCode] 1341. Movie Rating  (0) 2025.02.20
[LeetCode] 1327. List the Products Ordered in a Period  (0) 2025.02.20
[LeetCode] 1321. Restaurant Growth  (0) 2025.02.20