qiushui

摘要： 一。with ... as (...) 之前临时表都是一层一层嵌套的，最后嵌套下次很难阅读，使用这种方式可以大大提高sql的可阅读性 with temp1 as ( select * from ... where .. ), temp2 as ( select * from ... where... 阅读全文