MySql merge rows and show item count in result table?

Question

Is it possible to get the result as shown in this figure from the table:
enter image description here

How can i do this using mysql query?
Thank you,

judda · Accepted Answer · 2011-06-26 18:16:37Z

5

SELECT `UID`, `USER`, COUNT(RID) AS "RID-Count", SUM(`COUNT`) AS COUNT
FROM TABLE1
GROUP BY `UID`, `USER`

Assuming for cat the RID is NULL

answered Jun 26, 2011 at 18:10

judda

3,9721 gold badge27 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1