SQL:With
Syntax
스타일 가이드
Do not use nested queries. Instead, use common table expressions to improve readability.
Good:
WITH sample AS (
SELECT
client_id,
submission_date
FROM
main_summary
WHERE
sample_id = '42'
)
SELECT *
FROM sample
LIMIT 10
Bad:
SELECT *
FROM (
SELECT
client_id,
submission_date
FROM
main_summary
WHERE
sample_id = '42'
)
LIMIT 10
여러개 with
콤마(,
)로 구분하면 된다.
WITH sample AS (
SELECT * FROM aa WHERE uid=42
), sample2 AS (
SELECT * FROM bb WHERE uid=43
)
SELECT * FROM sample, sample2;