|
1
2
3
4
5
6
7
|
/* Write your PL/SQL query statement below */
select
p.firstname,p.lastname,a.city,a.state
from
person p, address a
where
p.personid=a.personid(+)
|
cs |
반응형
'SQL' 카테고리의 다른 글
| leetcode 182. Duplicate Emails (0) | 2022.03.17 |
|---|---|
| leetcode 181. Employees Earning More Than Their Managers (0) | 2022.03.17 |
| leetcode 595. Big Countries (0) | 2022.03.17 |
| Hacker rank Type of Triangle (0) | 2021.10.23 |
| Hacker rank Average Population of Each Continen (0) | 2021.10.23 |
댓글