求救，sql语句写错了。

[fxs320]

有一张表解leavesrecords 里面有ID,workid, leavedate,remark,leavetype 四个字段，现在要查workid和leavedate 字段相同重复的记录。
select * from leavesrecords a

where (a.workid,a.leavedate) 这边说有语法错误。

in (select workId,leavedate from leavesrecords group by workId,leavedate having count(*) > 1)

[SQL77]

SELECT * FROM leavesrecords  A 
WHERE EXISTS(SELECT 1 FROM leavesrecords WHERE workid=A.workid AND leavedate =A.leavedate  AND ID<>A.ID)

[SQL77]

语法没有这样的吧

[xuejiecn]

select * from leavesrecords where workid=leavedate

[xuejiecn]

[Quote=引用 1 楼 sql77 的回复:]
SQL codeSELECT*FROM leavesrecords AWHEREEXISTS(SELECT1FROM leavesrecordsWHERE workid=A.workidAND leavedate=A.leavedateAND ID<>A.ID)
[/Quote]
试试这个吧。

[有多少爱可以重来]

select * from leavesrecords where workid=leavedate

楼上正解

[ChinaJiaBing]

有一张表解leavesrecords 里面有ID,workid, leavedate,remark,leavetype 四个字段，现在要查workid和leavedate 字段相同重复的记录。
select * from leavesrecords a

where (a.workid,a.leavedate) 这边说有语法错误。

in (select workId,leavedate from leavesrecords group by workId,leavedate having count(*) > 1)

有一张表解leavesrecords 里面有ID,workid, leavedate,remark,leavetype 四个字段，现在要查workid和leavedate 字段相同重复的记录。 
select * from leavesrecords a 

where [id]

in (select [id]  from leavesrecords group by workId,leavedate having count(*) > 1)