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?

    何 風

      Hello,

       

      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 !