摘要: with语句查询可以将一个子查询作为一个结果,相当于一个i临时表多次使用 WITH t1 AS (SELECT 1 AS id,'bird' AS cname) , t2 AS (SELECT 1 AS id,'123' AS info) SELECT t1.cname,t2.info FROM t 阅读全文
posted @ 2023-04-19 17:49 朋羽 阅读(325) 评论(0) 推荐(0) 编辑