SQLite Forum

how DISTINCT remove the duplicate rows?
Thank you David.

I've read the passage you quoted, but I am still not sure how SQLite choose between the value-equal rows. If it's like what you said, will it be some randomness in the results?

If it's possible, I want to hear from developers.