INSERT INTO resource
            (interviewId)
VALUES      (SELECT resinterviewId
             FROM   resinterview
             WHERE  email IN (SELECT email
                              FROM   resinterview
                              GROUP  BY email
                              HAVING Count(email) >= 2))

------解决方案--------------------

SQL code
--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