随笔分类 -  SQL

with as才知道
摘要：https://www.cnblogs.com/shoshana-kong/p/16580840.html with name1 as ( select 脚本1 ), name2 as ( select 脚本2 ) select * from name1 a innert join name2 b 阅读全文
posted @ 2024-03-20 17:10 举起希望之灯 阅读(12) 评论(0) 推荐(0)
删除重复行
摘要：DELETE t1 FROM tmp202306253 t1INNER JOIN ( SELECT sid, buy_date, MAX(pkId) AS max_value FROM tmp202306253 GROUP BY sid, buy_date HAVING COUNT(*) > 1) 阅读全文
posted @ 2023-08-15 07:42 举起希望之灯 阅读(17) 评论(0) 推荐(0)