here is the scenario : my application will access BOOKS written by AUTHORS. The result set will look as follows
AUTHOR | BOOK
----------------------
kathy |
scjp
kathy | scwcd
kathy | HF
ejb
kathy | HF
java
horton | Beginning java
horton | Advanced Data Structures
horton | Regular Expressions in Java
.
.
.
Now my purpose is to randomly pick one record for each Author. I mean every time we access this resultset we want to randomly pick a different record i dont want that every time the resultset is created the first value is always the same. how do we do it?
would it be preffered approach to randomize the table created when we fire the query