分组求极值
分组按指定字段排序求极值数据截图需求按p_id分组后,获取min(p_order)对应行a的值,max(p_order)对应行b的最大值sql第一种方式:SELECT p_id,b,afrom(SELECT temp3.*, temp4.b FROM(SELECT test_xw.p_id, a FROM test_xwinner join(SELECT min(id) as id from test_xw GROUP BY p_id ORDER BY p_order) temp
原创
2020-09-09 11:12:59 ·
201 阅读 ·
0 评论