For random query

[Anon]

Hi all
I want a query for oracle such that if iam giving a query it should return 25 query results randomly.

For eg: select * from table;
will give all the records from that table

but i want in such a way that from table only 25 results should be shown and that records should be randomly generated.

Regards
Yogi

[babak]

Suggestion:

Get the number of rows in the table and then use this

for ($i=0;$i<25;$i++){
$num=rand($min_val,$num_rows);
if(!exists_in_array($array,$num)){
$array[] = $num;
}else{
$i--;
}
}

The you can run a loop and use the values in the $array as row_id in the query.

function exists_in_array($array,$val){
$found = false;
for($i=0;$i<count($array);$i++)
if($array[$i] == $val){
$found = true;
}
return $found;
}

//

[sepodati]

A simpler solution would be this query:

SELECT * FROM your_table ORDER BY RAND() LIMIT 25

It returns 25 random rows from your database...

---John Holmes...