3,333,300),
(4,111,101),
(5,111,102),
(6,222,201),
(7,222,202),
(8,333,301),
(9,333,302);
##DEMO1:找出最大的金额.../**
期望结果:
"id" "order_no" "max(amt)"
"1" "111" "102"
"2" "222" "202"
"3" "333" "302"
**/
##DEMO2:根据每个订单号找出...ID最大的一行记录
/**
期望结果:
"id" "order_no" "amt"
"5" "111" "102"
"7" "222" "202"
"9" "333" "302"
**/
##ID最小的这一行...SELECT * FROM `test_user` GROUP BY order_no
##简单方法:倒序然后再分组,可以查询出来。....* FROM (
SELECT * FROM `test_user` ORDER BY id DESC
) t GROUP BY order_no
##找出最大的这一条记录数
##方法1 根据ID来关联