Hi ,
We are looking for a way to pick up random rows from a standard table and assign them to all the records in a shuffled manner.
Eg: table name : Table_A , column name - name
It should randomly pick up the name values from Table_A and return a single row each time in my loop in a shuffled order. There are huge data and hence timing should be effective.
How can we achieve this?