phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sean Huo <s...@crunchyroll.com>
Subject counting returns different results
Date Tue, 10 Jun 2014 20:30:59 GMT
These two queries returns vastly different results:

query1:
select count(1) from t where date > 'certain day' and device ='A';

query2:

select device, count(1) from t where date >'certain day' and device ='A'
group by device;

assuming table t has the  composite primary key of
date timestamp, and device varchar.

What gives?

Mime
View raw message