retrieve values randomly ?

how can I retrieve values from database randomly ?
suppose in my database there are 13 rows . and I want to retrieve these in random order ?
is there any method to do it ?

you can do "order by rand()" .....if it is an rdbms ......

Not really. The best solution would be to randomize the returned data in the object/list/array you are storing them in.

How many records are we talking about? Unless your passing the result set to the presentation layer (scary) I don't see how your not putting things into memory. A resultset is just a database-backed hashmap.

Thank you Jean.. it works with order by rand()..
but is there any mechanism to fetch result randomly through function..
what is this ResultSet.FETCH_UNKNOWN... how to use it ?

There is no method in java to randomize result sets but it would be trivial to do so in an application.