with as的用法

with a as (select * from test)

select * from a;
其实就是把一大堆重复用到的SQL语句放在with as 里面，取一个别名，后面的查询就可以用它