Prakash Reddy Bande <prakashr-G0/[EMAIL PROTECTED]>
wrote:
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?
Essentially at random, in an unpredictable way. Whichever row falls
naturally out of its traversal algorithm. Why do you care?
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------