문제 - Replace Employee ID With The Unique Identifier
https://leetcode.com/problems/replace-employee-id-with-the-unique-identifier/
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 | +---------------+---------+ In SQL,
leetcode.com
Show the unique ID of each user, If a user does not have a unique ID replace just show null.
작성 답안
select eu.unique_id, e.name
from employees as e
left join employeeUNI as eu
on e.id = eu.id리뷰
-
'SQL' 카테고리의 다른 글
| [leetCode] #197 (날짜 차이 계산하기/TO_DAYS, DATEDIFF, SUBDATE) (0) | 2023.08.06 |
|---|---|
| [leetCode] #1581 (EXISTS) (0) | 2023.08.03 |
| [leetCode] #1683 (length와 char_length의 차이) (0) | 2023.07.31 |
| [leetCode] #1148 (쿼리실행순서) (0) | 2023.07.19 |
| [leetCode] # 584, 595, 1757 (coalesce를 통한 null 대체) (0) | 2023.07.18 |