|
1
2
3
4
5
6
7
8
|
select employee_id
from(
select employee_id from Employees
union all select employee_id from Salaries
)t
group by employee_id
having count(*)=1
order by 1
|
cs |
반응형
'SQL' 카테고리의 다른 글
| leetcode 1148. Article Views I (0) | 2022.03.31 |
|---|---|
| leetcode 511. Game Play Analysis I (0) | 2022.03.31 |
| leetcode 1179. Reformat Department Table (0) | 2022.03.31 |
| leetcode 1407. Top Travellers (0) | 2022.03.31 |
| leetcode 1890. The Latest Login in 2020 (0) | 2022.03.30 |
댓글