22,209
社区成员
发帖
与我相关
我的任务
分享
--两个表之间相同email
select a.[email] from [resource] a
inner join [resinterview] b
on a.[email]=b.[email]
INSERT INTO resource
(interviewId)
VALUES (SELECT resinterviewId
FROM resinterview
WHERE email IN (SELECT email
FROM resinterview
GROUP BY email
HAVING Count(email) >= 2))
--resource表
select t.[email] from
(
select [email],count(*) cnt from [resource]
group by [email]
) t
where t.[cnt]>1
----------------------
--resinterview表
select t.[email] from
(
select [email],count(*) cnt from [resinterview]
group by [email]
) t
where t.[cnt]>1