SELECT *
FROM tb_information
WHERE first_name
IN (
SELECT first_name
FROM tb_information
GROUP BY first_name
HAVING COUNT( * ) >1
)
AND last_name
IN (
SELECT last_name
FROM tb_information
GROUP BY last_name
HAVING COUNT( * ) >1
)
ORDER BY first_name DESC
SELECT *
FROM `tb_information`
WHERE `full_name`
IN (
SELECT `full_name`
FROM `tb_information`
GROUP BY `full_name`
HAVING COUNT( * ) > 1
)
ORDER BY `full_name` DESC
Load balance : Server 02
