Cloud Stack Ninja

Query 1:

with table1 as (select * from table2) delete * from table1;

Query 2:

with table1 as (select * from table2) delete * from table1 where col1 = 'something';

Both of the above query are returning error after execution? Can someone help me here?



Read more here: https://stackoverflow.com/questions/64401650/how-to-use-delete-clause-after-with-clause-in-postgresql

Content Attribution

This content was originally published by Rahul Kumar at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: