View Full Version : select random record

03-16-2005, 06:37 PM
I have the following code

select top 1 * from users

how can I instead of selecting the top just select a random record?

04-02-2005, 04:09 AM
order by rand()

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum