Newbie needs help with query

Newbie needs help with query

am 06.03.2007 08:54:20 von raj

Hi,

Is there a query which will select x random unique records out of all records
and sort them randomly, but if all records is smaller than x then it chooses
all the records and sorts them randomly.

e.g choose 3 random unique records out of all records (20) and sort them
randomly (5,1,14) , but if there are only 2 records it chooses the 2 records
and sorts them randomly (2,1).

Thank you in advance,

Raj (Newbie)