SQL
leetcode 1378. Replace Employee ID With The Unique Identifier
무적김두칠
2023. 4. 6. 15:39
https://leetcode.com/problems/replace-employee-id-with-the-unique-identifier/description/
Replace Employee ID With The Unique Identifier - LeetCode
Can you solve this real interview question? Replace Employee ID With The Unique Identifier - Table: Employees +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | name | varchar | +---------------+---------+ id is t
leetcode.com
|
1
2
3
4
5
|
# Write your MySQL query statement below
select un.unique_id , em.name
from Employees em
left join EmployeeUNI un
on un.id = em.id
|
cs |
반응형