select name
from
(select name,count(*) in from tablename where sort = I group by name) a,
(select name,count(*) out from tablename where sort = O group by name) b
where a.name = b.name
and a.in > b.out
不知道能不能跑出来?试一下吧!
select name
from table_name a
where (select count(*) from table_name b wehre a.id=b.id and b.sort=1)>(select count(*) from table_name c where a.id=c.id and c.sort=0)