mardi 12 mai 2015

SQL for MS Acces how to pick random row from a table?

I'm trying to make a Query from my Table "Questions", this table has the following fields: id(auto number), Question(text) ; Category(text), difficulty (number)

The query I'm trying to make must return one random row for every difficulty (1-5), for a given Category.

Aucun commentaire:

Enregistrer un commentaire