I am trying to get a random row from a certain set of rows within a table from a MS Access database.
The random record must come from the list of records with [Difficulty Level] = 1 and [Language Level] = 1.
In essence, I want to make a query of the records that have Diff.Level 1 and Langu.Level 1, and then from this query, get a random row.
I am using OleDb in SQL from VB.NET.
Any suggestions? This is my code so far:
SELECT TOP 1 * FROM [learningMaterial] WHERE rand() AND [Difficulty Level] = '1' AND [Language Level]= '1'
Thanks in advance!
Aucun commentaire:
Enregistrer un commentaire