[MySQL] With 예제

 

<예제 코드_1>

WITH RECURSIVE cte (n, fibonacci) AS (
  SELECT 1, 1
  UNION ALL
  SELECT n + 1, fibonacci + cte.fibonacci
  FROM cte
  WHERE n < 20
)
SELECT * FROM cte;

 

<출력 결과_1>

 

---

 

<예제 코드_2>

==> with를 통해 조건_1로 필터링 한 data를 조건_2로 다시 필터링

WITH cte AS (
  SELECT *
  FROM table_1
  WHERE condition_1
)
SELECT *
FROM cte
WHERE condition_2;

 

 

 

---

 

<참조 1> https://chat.openai.com/chat

<참조 2>