你即將離開本站

並前往https://www.titanwolf.org/Network/q/bc6649f4-1484-41b2-ad86-63e80811115b/y

Question How to get records randomly from the oracle ...

SELECT * FROM table SAMPLE(20);. Note: the 20 here is an approximate percentage, not the number of rows desired. In this case, since you have 100 rows, ...

確定！ 回上一頁

查詢 「Oracle random select」的人也找了：

  1. Oracle random select
    2.
  2. Oracle random string
    3.
  3. Oracle Sample
    4.
  4. Select * FROM (SELECT * FROM table)
    5.
  5. Oracle random number
    6.
  6. Oracle select first 10 rows
    7.
  7. Oracle where ROWNUM 1
    8.
  8. SQL ORDER BY random
    9.