oracle 或者 java 通过概率取得对应的值

Question

本帖最后由 zzwzxzs444 于 2013-09-24 10:14:09 编辑

Answer 1

SELECT ID,QUEUE_PRIORITY,RATIO_TO_REPORT(QUEUE_PRIORITY) OVER() FROM table
ORDER BY QUEUE_PRIORITY        ID QUEUE_PRIORITY RATIO_TO_REPORT(QUEUE_PRIORITY
---------- -------------- ------------------------------
         1            100            0.00925925925925926
         1            200             0.0185185185185185
         1            500             0.0462962962962963
         1          10000              0.925925925925926