MSSQL WITH AS 임시테이블 이용 쿼리

WITH 임시테이블명 AS

(

     SELECT * FROM 테이블명

)

SELECT * FROM 임시테이블명

ex 1) WITH #temp_table AS

(

select * from test

)

select  *  from #temp_table

ex 2) WITH #temp_table AS

(

select row_number() over(order by num) as NUMBER,* FROM from test

)

select  *  from #temp_table where NUMBER=1

주의사항 : with as () 감싼다음에 쿼리문이 존재하여야 한다 . 아님 에러 ㅡ.ㅡ;