1：查找某个字段相同
|
1
2
3
4
5
6
7
8
9 |
select
* from
orders where
serial_number in
(select
serial_number from
ordersgroup
by serial_numberhaving
count(serial_number) > 1) |
原文：http://www.cnblogs.com/lvyno/p/3754793.html