随笔分类 -  sql

SQL
摘要：WITH的使用 WITH t1 AS (SELECT r.name region_name, SUM(o.total_amt_usd) total_amtFROM sales_reps sJOIN accounts aON a.sales_rep_id = s.idJOIN orders oON o 阅读全文
posted @ 2021-11-04 16:54 whateveranyhow 阅读(31) 评论(0) 推荐(0)