CODE EXAMPLE FOR SQL

Having count greater than 1 mysql

SELECT * FROM `users`
WHERE AND `status` = 1
GROUP BY name
HAVING COUNT(*) > 1
ORDER BY `id` DESC