[SQL] WHERE 1=1

SELECT QUARTER(release_date) 분기, distributor 배급사, COUNT(*) 영화편수, ROUND(SUM(sale_amt)/ 100000000) 매출_억원
FROM box_office
WHERE 1=1
AND EXTRACT(YEAR FROM release_date) = 2019 
AND distributor IS NOT NULL
AND sale_amt >= 10000000
GROUP BY QUARTER(release_date), distributor
ORDER BY 1,2,3;

SELECT QUARTER(release_date) 분기, distributor 배급사, COUNT(*) 영화편수, ROUND(SUM(sale_amt)/ 100000000) 매출_억원
FROM box_office
WHERE 1=1
--AND EXTRACT(YEAR FROM release_date) = 2019 
AND distributor IS NOT NULL
AND sale_amt >= 10000000
GROUP BY QUARTER(release_date), distributor
ORDER BY 1,2,3;

https://reference-m1.tistory.com/337

[SQL] WHERE 1=1 의미