Published
- 1 min read
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