홍동이의 성장일기
[LeetCode] 175. Combine Two Tables 본문
Combine Two Tables - LeetCode
Can you solve this real interview question? Combine Two Tables - Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | personId | int | | lastName | varchar | | firstName | varchar | +-------------+---------+ personId i
leetcode.com
select p.firstname, p.lastname, a.city, a.state
from person p left join address a
on p.personId = a.personId;
💡 개념정리
LEFT JOIN
on으로 동일한 컬럼 연결해주기
728x90
'Tool > SQL 코딩테스트 풀이' 카테고리의 다른 글
| [LeetCode] 1179. Reformat Department Table (0) | 2023.08.12 |
|---|---|
| [LeetCode] 602. Friend Requests II: Who Has the Most Friends (0) | 2023.04.17 |
| [HackerRank] Type of Triangle (0) | 2023.04.17 |
| [HackerRank] The PADS (0) | 2023.04.17 |
| [HackerRank] Weather Observation Station 3 (0) | 2023.04.17 |
'Tool/SQL 코딩테스트 풀이' Related Articles
more
Comments