I’m using the below query but it’s not giving me the exact
SELECT userSessionId, COUNT(*) FILTER > 1 FROM usersession GROUP BY userSessionId
This give me the table with all the results, but I’m looking for the total number of groupings. Basically, this is the result:
| userSessionId | count(*) |
|---|---|
| XXXXXXXX | 3 |
| XXXXX | 3 |
| XXXXXXXXX-XX | 2 |
| XXXXX | 2 |
| XXXXXXXXXXXXXXX | 2 |
However, I’m looking to get 5 - or the total number of rows (groups) in the table.
Is this possible?

