On 30-6-2018 15:45, Luuk wrote: > > In SQLite3 you are allowed to do this: > SELECT a,b,c > FROM t1 > GROUP BY a > > The values of 'b' and 'c' will be taken from a 'random' row... > > But if we rewrite this in SQL, i am getting something like this: > SELECT > a, > (SELECT MIN(b) FROM T1 WHERE a=t.a) AS B, > (SELECT MIN(c) FROM T1 WHERE a=t.a) AS C > FROM t1 t > GROUP BY a > > QUESTION: How does one get the proper relationship between 'B' and 'C'?, > i mean how can one be use that both values are from the same row? > This is not a problem to SQLite, because in SQLite the values of b and c > seems to be originating from the same row, but what about *SQL* (if that > exists...?) >
I think i'll do this: select x.a, t1.b, t1.c from (select t1.a, min(t1.rowid) from t1 group by t1.a) x inner join t1 on x.rowid=t1.rowid; _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
