Thread: Select a row at random?
View Single Post
  #3 (permalink)  
Old 04-21-2006, 01:53 PM
Josh Ross
 
Posts: n/a
Default MS SQL answer. Re: Select a row at random?
[sql]SELECT top 1 word FROM dictionary ORDER BY rand(checksum(word + convert(varchar(23),getdate(),21)))[/sql]
Edit/Delete Message Reply With Quote