Get repeated rows in based on child table from Parent table
SELECT * FROM `parents` WHERE id IN ( SELECT parent_id FROM `tbl_parent_child` GROUP BY parent_id HAVING COUNT ( parent_id ) = 2 )
Hi My name is Mahesh Babu. Bokkisam, I am working for ICS as Technical Lead, Bengaluru, INDIA.
I have total 12+ years of experience in IT with different technologies like PHP, MySQL, Angular, React, Knockout, MongoDB.