Find Customer Referee - LeetCode
Can you solve this real interview question? Find Customer Referee - Table: Customer +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | referee_id | int | +-------------+---------+ In SQL, id is the
leetcode.com
전체 코드
SELECT name
FROM Customer
WHERE referee_id != 2
OR referee_id is NULL'Coding Test > SQL' 카테고리의 다른 글
| [프로그래머스/SQL 고득점 Kit] SELECT ALL SOLVE (1) | 2024.01.10 |
|---|---|
| [LeetCode] 1683. Invalid Tweets (easy, SQL) (0) | 2024.01.09 |
| [LeetCode] 1148. Article Views I (easy, SQL) (1) | 2024.01.09 |
| [LeetCode] 595. Big Countries (easy, SQL) (0) | 2024.01.09 |
| [LeetCode] 1757. Recyclable and Low Fat Products (easy, SQL) (0) | 2024.01.09 |
