Concatenate 2 columns in user sessions query

[alexandre_benel]

Hi guys,

Is there a way to concatenate 2 or more columns/strings in user session query? Something like that:

select screenHeight || "x" || screenWidth from usersession

So the result would be: 1280 x 720

Tks

[JamesKitson · Accepted solution]

No, but if you're looking for resolution info I've done something like that previously. Might need to adjust it to fit your needs but the below gives top screen resolutions for mobile apps.

SELECT screenHeight as height, screenWidth as width, count(*) as "Session count" from usersession where applicationType = "MOBILE_APPLICATION" group by screenHeight, screenWidth ORDER BY count(*)

[alexandre_benel]

Tks James!