Posted by raj on 03/06/07 07:54

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)

• Next in forum: Re: Newbie needs help with query
• Prev in forum: Re: NULL fields in table - efficiency question
• Thread view: Newbie needs help with query

[Reply to this message]