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 |
반응형
'SQL' 카테고리의 다른 글
| leetcode 1251. Average Selling Price (0) | 2023.04.07 |
|---|---|
| leetcode 2356. Number of Unique Subjects Taught by Each Teacher (0) | 2023.04.06 |
| leetcode 1683. Invalid Tweets (0) | 2023.04.06 |
| leetcode 1393. Capital Gain/Loss (0) | 2023.01.26 |
| hackerrank Occupations (0) | 2022.11.13 |
댓글