Lim Seunghyun Space

[Leetcode] 183. Customers Who Never Order 본문

SQL/SQL 문제

[Leetcode] 183. Customers Who Never Order

Lim Seung Hyun 2022. 3. 23. 15:25

문제 출처

 

Customers Who Never Order - LeetCode

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

leetcode.com

 

나의 풀이 (not in 사용)

select c.name as Customers
from Customers as c
where c.id not in (select distinct(customerId) from Orders)

 

나의 풀이(not exists 사용)

select c.name as Customers
from Customers as c
where not exists (select * from Orders as o where c.id = o.customerId)
728x90
저작자표시 (새창열림)

'SQL > SQL 문제' 카테고리의 다른 글

[Leetcode] 196. Delete Duplicate Emails  (0) 2022.04.18
[Leetcode] 184. Department Highest Salary  (0) 2022.03.25
[Leetcode] 182. Duplicate Emails  (0) 2022.03.23
[Leetcode] 181. Employees Earning More Than Their Managers  (0) 2022.03.23
[HackerRank] Type of Triangle  (0) 2021.11.30
'SQL/SQL 문제' Related Articles more