sql with clause within a with clause

Question

can i do something like this :

with t as 
    (
        with tt as
            ( 
                 select * from table 
            )
        SELECT * FROM tt
    )
select * from t

i willing to perform some logic on output of inner with clause & than again do some operations on output of the outer with clause.

any help will be appreciated ...
Thanks

note :- its just some simplified query that will resolve my problem in my actual query, which have nested with clause

Answer 1

You can do something like this:

with t as 
(
    select * from table
),
tt as
( 
     select * from t
)
select * from tt 

Answer 2

No, you cannot nest CTE (Common Table Expression) but you can chain them:

with t as 
(
    select * from table 
),
tt as
( 
    select * from t
)
SELECT * FROM tt