4 Replies Latest reply: Oct 6, 2016 4:58 AM by Solomon Jeyaseelan RSS

    How to reload 10% of the Total records from a table randomly?

    何 風



      I have no idea how to reload 10% of the total records randomly.


      For ex:

      I have a Table which has 1000 records, and I  want to load just 100(10%) records randomly.


      I tried 'sample 0.1' command , but it doesn't load just 100(10%) records for me. sometimes 9%, and sometimes 11%, maybe more or less.


      Does anybody have a solution for resolving this ?


      Thanks a lot !