songwen_120的博客

分组按指定字段排序求极值 数据截图 需求 按p_id分组后，获取min(p_order)对应行a的值，max(p_order)对应行b的最大值 sql 第一种方式： SELECT p_id,b,a from ( SELECT temp3.*, temp4.b FROM ( SELECT test_xw.p_id, a FROM test_xw inner join (SELECT min(id) as id from test_xw GROUP BY p_id ORDER BY p_order) temp