Count Number of Groupings

[awassel]

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?

[p_devulapalli]

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

[Peter_Youssef · Accepted solution]

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,