Home

Published

- 1 min read

group by count greater than 1 sql

img of group by count greater than 1 sql

The solution for this is noted below

group by count greater than 1 sql

Solution

   SELECT user_id, user_email, user_phone, first_name, last_name
FROM user_info,user_contact_info
WHERE user_id=contact_user_id
GROUP BY contact_user_id
HAVING
COUNT(contact_user_id) > 1
ORDER BY c_id DESC, id DESC;

Try other methods by searching on the site. That is if this doesn’t work