sql with clause within a with clause

sql sql-server with-clause
objectWithoutClass picture objectWithoutClass · Aug 2, 2013 · Viewed 18.9k times · Source

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

Giannis Paraskevopoulos picture Giannis Paraskevopoulos · Aug 2, 2013

You can do something like this:

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

Related questions

SQL Server - using the WITH clause in an INSERT statement

I was wondering if this was possible. I have an existing query that uses the WITH clause to apply some aggregated data to a SELECT query like so: (massively simplified) ;WITH alias (y,z) AS ( SELECT y,z FROM tableb ) …

Read More
How to create a table using "With" clause in SQL

I'm attempting to create a persistent table using the WITH clause however, I'm getting an error. For context the answer that I currently find is CREATE TABLE my_table AS WITH my_tables_data AS ( SELECT another_table.data1 AS …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More