随笔分类 -  sql

sql分组求最大值
摘要：select * from(select *,ROW_NUMBER() OVER(PARTITION BY type ORDER BY typeindex DESC) as numfrom test) twhere t.num = 1 https://www.cnblogs.com/lakeliu/ 阅读全文
posted @ 2022-01-07 17:42 娜乌西卡在路上 阅读(219) 评论(0) 推荐(0)