Count Number of Groupings

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?

Hi @awassel ,   Does something like below work ? If not, could you please elaborate your query a bit further

SELECT COUNT(DISTINCT userSessionId) AS sessionCount
FROM usersession

Hi @awassel

As per the attached query the below result will be presented

And as per the query provided by @p_devulapalli, the below result is presented.

BR,