[Oracle] WITH AS

WITH 테이블 이름 AS
(SELECT 문)
[SELECT 문]

호출 (SELECT 테이블이름.컬럼 FROM 테이블이름)

---

WITH T AS	-- 테이블 생성
(SELECT HOLD_NO, MAX(SEQ) FROM JAVA_BOOK_RENT
WHERE RETURNYN = 'N'
GROUP BY HOLD_NO)
SELECT * 
FROM JAVA_BOOK_HOLD
WHERE HOLD_NO NOT IN (SELECT T.HOLD_NO FROM T)