Random Function

From: Sachin Puri <sachin_at_siworldwide.com>
Date: Fri, 12 Jan 2001 19:20:17 +0530
Message-Id: <10739.126486@fatcity.com>

Is there any Random function except dbms_random to generate a random number in Oracle.
Can anyone tell me how to retrieve a random record from a query if there are duplicate records.

e.g

Select * from A

Userid Rate

1         3 
2         3
3         3
4         3

I want to have a random userid with rate = 3 i.e one time userid 2 is retrieved,some other time userid 4 and so on. Can anyone help me regarding this. Received on Fri Jan 12 2001 - 07:50:17 CST