...

View Full Version : select random record



esthera
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?

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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum