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.
