I am not an expert in SQL, so do bear with me if I am asking the obvious. Given:
timestamp | col1 | col2 ============================ xx abc 5 yy abc 4 zz def 7 rr def 6 SELECT timestamp, col1, min(col2) FROM table GROUP BY col1 ORDER BY min(col2) ASC returns: xx abc 4 zz def 6 It looks like the timestamp column is kind of random since it is not part of the group by clause. Suppose I want the results to be: yy abc 4 rr def 6 what kind of SQL would I have to write? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
