vendredi 11 novembre 2016

How to select a random row from a MS Access through VB.NET within a certain set of requirements?

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