SQLite Forum

how DISTINCT remove the duplicate rows?
Login
The first projection result that is distinct will be output.  Subsequent duplicates will be suppressed.