Re: [sqlite] Group by without aggregates

2007-09-20 Thread Joe Wilson
> How does SQLite choose which row to return from a group? http://www.mail-archive.com/sqlite-users@sqlite.org/msg17778.html Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail,

[sqlite] Group by without aggregates

2007-09-20 Thread Prakash Reddy Bande
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