查询重复记录

Java代码
select * from order_ticket ot Where ot.ticket_id In (select ot.ticket_id from order_ticket

Group By ot.ticket_id Having Count(*)>1) order by ot.ticket_id

作者“刘文涛”