lundi 25 avril 2016

Sqlite DISTINCT inconsistant results

I am getting very different results just by adding a DISTINCT that shouldn't do anything.

My table has ~10000 rows with unique rowids.

However, when I run:

SELECT DISTINCT * FROM thetable GROUP BY rowid

I only get ~6000 of the rows. What?? Shouldn't every row be distinct since every row has a different row id?

Aucun commentaire:

Enregistrer un commentaire