728x90
https://programmers.co.kr/app/with_setting/tests/120812/challenges/databases/133
select *
from (
SELECT *, 0 as likes
from old_posts
union
select *
from new_posts ) a
order by id desc;
728x90
'𝙎𝙌𝙇' 카테고리의 다른 글
PCSQL 모의고사 for Guest (4) (0) | 2024.07.16 |
---|---|
PCSQL 모의고사 for Guest (2) (0) | 2024.07.16 |
PCSQL 모의고사 for Guest (3) (0) | 2024.07.16 |
문자열 합치기 CONCAT('A', 'B') (0) | 2024.03.27 |
[HackerRank] Weather Observation Station 5 (0) | 2023.08.09 |