求救，sql语句写错了。

Question

有一张表解leavesrecords 里面有ID,workid, leavedate,re,leavetype 四个字段，现在要查workid和leavedate 字段相同重复的记录。
select * from leavesrecords awhere (a.workid,a.leavedate) 这边说有语法错误。 in (select workId,leavedate from leavesrecords group by workId,leavedate having count(*) > 1)

Answer 1

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

Answer 2

select * from leavesrecords where workid=leavedate

Answer 3

select * from leavesrecords where workid=leavedate楼上正解

Answer 4

有一张表解leavesrecords 里面有ID,workid, leavedate,re,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,re,leavetype 四个字段，现在要查workid和leavedate 字段相同重复的记录。 
select * from leavesrecords a where [id]in (select [id]  from leavesrecords group by workId,leavedate having count(*) > 1)