On 12/14/2011 8:45 PM, Jeff Matthews wrote:
Did you get my response? I thought of something that you should try, which
is adding a where clause.
SELECT timestamp, col1, min(col2)
FROM table
WHERE col2=min(col2)<----- Here
GROUP BY col1
ORDER BY min(col2) ASC
This would produce an error during prepare, "misuse of aggregate". You
can't use aggregates in a WHERE clause. I'll leave it as an exercise for
the reader to figure out why.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
