SELECT
id,
email,
phone
FROM
table
WHERE (
email,
phone
)
IN (
SELECT
email,
phone
FROM
table
GROUP BY
email,
phone
HAVING COUNT(id) = 1
)
SELECT DISTINCT
email,
phone
FROM
table
SELECT * FROM table1 t1, (
SELECT DISTINCT
email,
phone
FROM
table) AS t2
WHERE t1.email = t2.email AND t1.phone = t2.phone