AAA BBB CCC
-----------------------------------------------
A1 B1 0
A1 B2 1
A0 B3 0
A0 B4 1
A0 B5 2
A2 B0 0
A2 B6 1
A3 B10 0 结果为下面的aaa bbb ccc
---------------------------------------------------
A1 B1 0
A0 B3 0
A2 B0 0
A3 B10 0这个语句该怎么写?
-----------------------------------------------
A1 B1 0
A1 B2 1
A0 B3 0
A0 B4 1
A0 B5 2
A2 B0 0
A2 B6 1
A3 B10 0 结果为下面的aaa bbb ccc
---------------------------------------------------
A1 B1 0
A0 B3 0
A2 B0 0
A3 B10 0这个语句该怎么写?
(select aaa,min(ccc) ccc from tb group by aaa) b
where a.aaa = b.aaa and a.ccc = b.ccc
-----------------------------
A1 B1
A1 B2
A0 B3
A0 B4
A0 B5
A2 B0
A2 B6
A3 B10 结果为下面的aaa bbb
--------------------------------
A1 B1
A0 B3
A2 B0
A3 B10
select aaa,min(bbb) aaa from tb group by aaa
-> aaa = min(bbb)