有关group by 排序的问题,请进
有这样一个表:tab1
+----+-------+--------+-------+
| id | aa | bb | cc |
+----+-------+--------+-------+
| 1 | 0001 | 1 | 10 |
| 2 | 0001 | 2 | 10 |
| 3 | 0002 | 6 | 10 |
| 4 | 0003 | 5 | 10 |
| 5 | 0003 | 7 | 10 |
| 6 | 0003 | 4 | 10 |
| 7 | 0004 | 3 | 10 |
+----+-------+--------+-------+
用了下列语句:
select aa,bb,sum(cc) as cc from tab1 group by aa order by cc desc,bb desc
输出结果如下:
aa bb cc
======================
0001 1 20
0002 6 10
0003 5 30
0004 3 10
我想要的结果是:
aa bb cc
======================
0001 1 20
0002 6 10
0003 4 30
0004 3 10
也就是说字段bb对应的数据库中最新一条数据的值,这个如何实现???