19 Jun
2015
19 Jun
'15
1 a.m.
I might be doing something wrong, but should this really throw a division by zero?
SELECT count(*) / ((max("end")-min(start)) / 60) FROM table GROUP BY s HAVING max("end")-min(start)<>0 ;
Strangely enough, this works:
SELECT count(*) / ((max("end")-min(start))) FROM table GROUP BY s HAVING max("end")-min(start)<>0;
Am I doing something wrong?
Thanks
Raffael
—
Visual Analytics Workshop at #BlackHat US in August: http://bit.ly/1FN1W5e Raffael Marty ceo @ pixlcloud http://pixlcloud.com @raffaelmarty http://raffy.ch