ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From macdoug1 <macdo...@swbell.net>
Subject RE: Can't figure out the SQL syntax for this.Does anyone know?
Date Wed, 25 Apr 2007 18:28:52 GMT

That works. I guess my problem was I didn't understand how the random
function part was working. I figured that somehow I would need to give it
the number but I guess I was wrong. Thanks.

Gustavo Henrique Sberze Ribas wrote:
> 
>> information I want randomly but I can only figure out how to 
>> get one record. Anyone have any ideas?
> 
>   What about using 'rownum <= [number_of_desired_records]' ?
>  
>  (SELECT card_number, promo_id FROM cell_card
>    where cell_id = 246 ORDER BY dbms_random.value )
>  WHERE rownum <= 10;
> 
> 
> --
> Gustavo
> 
> 

-- 
View this message in context: http://www.nabble.com/Can%27t-figure-out-the-SQL-syntax-for-this.Does-anyone-know--tf3646279.html#a10186773
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message