CODEWITHSUNDEEP
sqloracle-databasecommon-table-expression
Tony Nguyen
Tony Nguyen

Reputation: 73

Can I use With within another with?

I am trying to create something like this but end up in errors. Not sure if this is the right way to do.

WITH SECONDMAIN AS
(
     WITH MAIN AS
     (
         SELECT
         ....
     )
     SELECT
        *
     FROM MAIN M
     JOIN ....
)

SELECT * FROM SECONDMAIN SM;

Upvotes: 0

Views: 141

Answers (1)

mkRabbani
mkRabbani

Reputation: 16918

The syntax would be-

 WITH MAIN AS
 (
     SELECT
     ....
 ), 
 SECONDMAIN AS
 (
     SELECT
        *
     FROM MAIN M
     JOIN ....
)

SELECT * FROM SECONDMAIN SM;

Upvotes: 3

Related Questions