select * from tb_aftermarket 
where 
order_number in 
(
select order_number from tb_aftermarket 
group by order_number having count(order_number) > 1
)