Post reply

Stuck with SQL can you help?

  • March 22, 2015 at 3:56 pm

    #150872

    I'm using phpMyAdmin

    There is a table called "parents" with attributes: parentID, parentName

    There is also a table called "children" with attributes: childID, childName, parentID

    I need to know the SQL to show names of all parents who have more than one child, together with the number of children that they have.

    The best I can come up with is this but it's causing errors.

    SELECT parentName, count(*)

    FROM parents

    JOIN children ON parentName

    GROUP BY parentName

    HAVING COUNT (childName) >= 1

  • March 23, 2015 at 11:23 am

    #1785779

    You have to correct your join clause. Your HAVING clause has an issue as well.

    SELECT parentName, count(*)

    FROM parents p --Alias parent table

    JOIN children c --Alias children table

    ON p.parentName = c.parentName --Use correct join syntax

    GROUP BY parentName

    HAVING COUNT (childName) > 1 --Only greater than

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply