vendredi 7 avril 2017

How to mix ASC and RANDOM() on SQLite ORDER BY

So, I'm facing an error while tryng to use ORDER BY for 2 columns:

... ORDER BY val, random();

Error is: "2nd ORDER BY term does not match any column in the result set"

I tryed differente ways to combine ASC sorting for 1st column and random sorting for second column, no luck.




Aucun commentaire:

Enregistrer un commentaire