where trade_id in (select trade_id from KKTtrade_detail group by trade_id having count(trade_id) > 1)
and id not in (select min(id) from KKTtrade_detail group by trade_id having count(trade_id )>1)
转载于:https://blog.51cto.com/3876775/1034603