phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sean Huo <s...@crunchyroll.com>
Subject order by problem
Date Thu, 06 Feb 2014 01:08:25 GMT
This query works correctly

select event_name, count(1) cnt from events where event_type ='some type'
group by event_name order by cnt desc;

But this query doesn't

select event_name, count(distinct uid) cnt from events where event_type
='some type' group by event_name order by cnt desc;

Mime
View raw message