Hi,
I have the following table: CREATE TABLE users (SMD_cid varchar(50), uname varchar(50), version integer); select SMD_cid, uname, version from users; 2a946e78-0659-4746-aab7-6486ae9a26d3|auser|1 b0b520e9-54b3-224d-8183-09ef08501451|auser|1 9272f455-2c2a-7e4d-a140-c30fac34ab09|auser|0 66c6263d-e792-f94e-8f57-fd49c2e7b6a6|auser|0 select SMD_cid, uname, version from users group by version; SMD_cid|uname|version 66c6263d-e792-f94e-8f57-fd49c2e7b6a6|auser|0 b0b520e9-54b3-224d-8183-09ef08501451|auser|1 I was excepting an error saying columns SMD_cid and uname are not aggregate. But the query did give some results. How does SQLite choose which row to return from a group? Regards, Prakash Reddy Bande Altair Engg. Inc, Troy, MI