SQL 查询重复的行

select * from tbsold 
where orderid in (select orderid from tbsold group by orderid having count(orderid) > 1) 
order by orderid