Running a query and I get different results for one field each time I run it. Any explanation for why this might happen?

SELECT id, week(fromDateTime(datefield, 'yyyy-MM-dd')) as week, SUM(f1 * f2 * f3) AS "ftotal" ****THIS IS THE FIELD THAT RETURNS DIFFERENT RESULTS****
FROM mytable
WHERE year(fromDateTime(datefield, 'yyyy-MM-dd')) >= cast(year(now())-2 as long)
  AND id in (123, 1234, 12345) AND f4 = 'blah' AND f5 in ('1-2', '3-4') AND f6 in ('foo', 'bar')
GROUP BY 1, 2

Different result for the same group or it returns different groups?

Actually you’re right, it is returning different groups based off the second column. It looks like it is limiting the results to 10 (I am using the query console) but I don’t have a limit in my query

Yes, the limit is 10 by default if not specified

whoops, PEBKAC haha. Thanks Jackie!