T-SQL query and group by reporting help
- by Dayton Brown
So I have some data that looks like this.
`USERID1 USERID2`
1 10
2 20
2 30
3 40
3 50
1 10
2 20
2 30
3 50
I want a query that produces the following
`USERID1 COUNT`
2 2
3 2
It's a group by query that shows me the count…