Hi All,
I have got a situation where i need to get records from database in such a way that, the records should be random form every given N number of records.
Let me explain with example
If the given N be 10 and total records in table be 100 then
i need to fetch one random record from every 10 records present in the table
so total i need 10 records in a way that
1st record from 1-10 records
2nd from 11-20 records
3rd from 21-30
.
.
.
10th from 91-100
Is it possible to get?
Please give me some solution.
Thanks in advance