Will thanks Jad, but i think you didn't get the point,
what I need is an SQL statement that selects a number of rows randomly (every time with a diffrent result)
like if I have a table with 100 records, I want for example the first query to result in fields 9,53,29,78,65 and when I run it again for example the records 74,68,12,39,92 and so on.
I hope I'm clear
On 6/30/05, Jad Madi <[EMAIL PROTECTED]> wrote:
RAND() ?
_______________________________________________
General mailing list
[email protected]
http://mail.jolug.org/mailman/listinfo/general_jolug.org
--
Ala'a A. Ibrahim
_______________________________________________ General mailing list [email protected] http://mail.jolug.org/mailman/listinfo/general_jolug.org
