Select Random Record From Database Table

Question

User150370776 posted

I need to select a random record from my database table, how can I do this? My query currently is:

SELECT        FN, LN, Rate
FROM            Data
ORDER BY Rate DESC

Answer 1

User-1508232475 posted

Hi, 

please check this  query 

SELECT TOP 1 FN,LN,Rate FROM DATA ORDER BY Rate,NewID() desc 

thanks,

Answer 2

User150370776 posted

It selected the first record, when I tried to rerun the query it didn't change

Answer 3

User150370776 posted

I toyed with the query for a while and I finally fixed it, I had to remove "Rate," from it.

Answer 4

User-1199946673 posted

This question is posted in the Access Databases and AccessDataSource Control forum. But if this works, it means that you're using SQL Server, not Access, so this post should be moved...