table a
col_1 col_2, col_3
a rw 1
a tw 2
b rw 3
b tw 2
找出 相同col_1 rw 的col_3值比tw大的
select *
from (select * from a t1 where col_2 = 'rw') tt1,
(select * from a t2 where col_2 = 'tw') tt2
where tt1.col_1 = tt2.col_1
and tt1.col_3 > tt2.col_3