예를 들어,
SELECT *
FROM crimes
WHERE date IN (SELECT DISTINCT date FROM crimes ORDER BY date DESC LIMIT 5);
위와 같은 SQL문을

WITH sub AS (
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SELECT DISTINCT date
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FROM crimes
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ORDER BY date DESC
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LIMIT 5
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)
SELECT *
FROM crimes
WHERE date IN sub.date

이렇게 쓸 수 있나요!?

안녕하세요 헬로월드님, 답변 드립니다.

WITH 절에 만든 테이블을 FROM 절을 통해 불러오는 과정이 필요합니다. 따라서 <code>IN (SELECT date from sub)</code> 와 같이 사용하시면 결과를 출력하실 수 있습니다.

감사합니다 :)

인프런 커뮤니티 질문&답변

WITH문을 WHERE절 서브쿼리에서도 사용할 수 있나요?