with a as (select * from test)
select * from a;
其实就是把一大堆重复用到的SQL语句放在with as 里面,取一个别名,后面的查询就可以用它
转载于:https://www.cnblogs.com/xushining/p/3711210.html
with a as (select * from test)
select * from a;
其实就是把一大堆重复用到的SQL语句放在with as 里面,取一个别名,后面的查询就可以用它
转载于:https://www.cnblogs.com/xushining/p/3711210.html