how to use RAND() in select statement?

[vidhya raman]

I want to select two columns from a table and arrange one column randomly using RAND().how to achieve this?

[Rabbit]

You can try a RAND column in a subquery in the place of your table in the FROM statement or you can ORDER BY RAND. I don't know which method would execute the fastest.

[vidhya raman]

Thank u...