How to get random records from an access database in asp?

how to get random records from an access database in asp?


I just want the sql query.How to get random records from an access database in asp?
select * from table order by field rand()How to get random records from an access database in asp?
SELECT TOP 1 *


FROM YourTable


ORDER BY Rnd(YourColumn);