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