𝙎𝙌𝙇

PCSQL 모의고사 for Guest (1)

콜라맛갈비 2024. 7. 16. 20:00
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