SQLite Forum

Different results in SELECT DISTINCT
Login
This behavior seems correct to me.  And PostgreSQL, MySQL, SQL Server,
and Oracle all work the same way.