100_replace_employee_id_with_the_unique_identifier.md

SQL Everyday #100

Replace Employee ID With The Unique Identifier

Site: LeetCode
Difficulty per Site: Easy

Problem

Write a solution to show the unique ID of each user, If a user does not have a unique ID replace just show null.

Return the result table in any order. [Full Description]

Submitted Solution

-- Submitted Solution
SELECT 
    e2.unique_id
    ,e1.name
FROM Employees as e1
LEFT JOIN EmployeeUNI as e2 ON e1.id = e2.id
;

Site Solution

-- LeetCode Solution 
-- Site solution essentially the same.

Notes

TODO

NB

TBD

Go to Index
Go to Overview