--COMMENT-----TRUNCATE table1 ; --COMMENT-----WITH table5 AS ( SELECT DISTINCT col1, col2, col3 FROM table6 ...