SQLite Forum

how DISTINCT remove the duplicate rows?
Thank you Keith.

Does this mean that the final output row depends on the order of scanning the projection candidates?

Forget this example. By changing the order of scanning origin table, just like adding and using an index, the order of projection candidates will change with it. In that case, will the result change from 1 to 1.0? Isn't it confusing?