如何查出一个表中两个字段有重复的记录.

[bluesun]

select lawunit,lawdate,count(*) from law_law group by lawunit,lawdate having count(*)>1
用上面的可以查出两个字段重复的内容,但是要把所有这些重复的记录比如说这个表有个字段id,要查出来就查不了.

[肥胖的柠檬]

select * from 表 a where exists(select 1 from 表 where 重复字段=a.重复字段)

[肥胖的柠檬]

看错了~SORRY ..不对DE

[肥胖的柠檬]

Select * From law_law A
Where Exists (Select Count(1) From law_law Where lawunit = A.lawunit And lawdate = A.lawdate Having Count(1) > 1)


这样

[SoftwKLC]

---这样就可以了
Select
*
From
law_law A
Where
Exists(
Select 1 From law_law Where lawunit = A.lawunit And lawdate<A.lawdate
)
--或者
Select
*
From
law_law A
Where
Exists(
Select 1 From law_law Where lawunit = A.lawunit And id<A.id
)

[madfrogzt]

select * from 表 a where exists(select max(id) from 表 where 重复字段=a.重复字段)

[lang8134]

你把你现在的再关联下就可以了啊.
----------------------------------------------------------------------------------
select a.* from law_lawa a,
(select lawunit,lawdate from law_law group by lawunit,lawdate having count(*)>1) b
where a.lawunit=b.lawunit and a.lawdate=b.lawdate

[SoftwKLC]

---如果要查lawunit和lawdate 重复的话Try
---用Exists速度要快
Select * From law_law A Where
Exists(Select 1 From law_law
Where lawunit = A.lawunit And lawdate=A.lawdate And id<A.id)

[y_dong119]

都快，我jf