[求助]一条sql语句的写法:如何找出多个列组合起来重复的记录?

tomorrower

我有一个表dsjb
(id,dq,bcpd,dsj,********)

现在我要得到:根据dq,bcpd,dsj三个字段,这三个字段一样的记录重复的记录,就是得到这三个字段一致的多于一行的全部记录

我使用select dq,bcpd ,dsj from dsjb group by dq,bcpd ,dsj having(count(*))>1 ;可以得到重复的dq,bcpd ,dsj ,但是如何得到所有字段呢?

doni

select * from ...
where (a,b,c) in (
select a,b,c from ..
group by a,b,c
having count(*) > 1)

tomorrower

原帖由 doni 于 2009-3-30 18:30 发表
select * from ...
where (a,b,c) in (
select a,b,c from ..
group by a,b,c
having count(*) > 1)

谢谢,可惜我用的sybase的asa数据库不支持(a,b,c) in