My data looks like this:
queryable_type queryable_id User 1 User 2 User 2
I'd like to return dupes so that my result would look like this:
queryable_type queryable_id count User 2 2
I'm assuming some multiple group by but it wasn't working.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community