请教高手，怎样找出表中重复的记录，这句SQL语句怎么写？
table customer
{
customer_id char(3),
customer_name char(40),
customer_address char(80)
};
有这样几条记录，
customer_id customer_name customer_address
001 ... ...
002 ... ...
003 ... ...
... ... ...
002 ... ...
003 ... ...
找出customer_id为'002'或'003'的记录，这句SQL语句怎么写？
问题点数：20、回复次数：2Top
1 楼ASPCOMjsp（）回复于 2003-12-01 11:17:01 得分 0
select * from customer where customer_id in ('002','003');Top
2 楼chuangT（chuangT）回复于 2003-12-01 11:42:16 得分 20
select * from customer where customer in (select customer_idfrom customer group by customer_id
having count(*)>1);
Top
