Given a table in the format of
ID Forename Surname 1 John Doe 2 Jane Doe 3 Bob Smith 4 John Doe
How would you go about getting the output
Forename Surname Count John Doe 2 Jane Doe 1 Bob Smith 1
For a single column I would just use count, but am unsure how to apply that for multiple ones.
SELECT Forename, Surname, COUNT(*) FROM YourTable GROUP BY Forename, Surname
I think this should work:
SELECT Forename, Surname, COUNT(1) AS Num
FROM T
GROUP BY Forename, Surname
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With