mysql语句

1：查找某个字段相同

select * from orders where serial_number in (

select serial_number from orders

group by serial_number

having count(serial_number) > 1

)