Recipe 1.10. Returning n Random Records
select *
from (
select ename, job
from emp
order by dbms_random.value()
)
where rownum <= 5
from (
select ename, job
from emp
order by dbms_random.value()
)
where rownum <= 5
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23895263/viewspace-680977/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Recipe 4.11. Merging Records
- Retrieving the First N Records from a SQL QuerySQL
- C#9.0:RecordsC#
- Debug-Records
- 5.編寫recipe
- 精讀《Records & Tuples for React》React
- 【原創】MySQL 返回更新值(RETURNING)MySql
- Deployer recipe中Laravel配置檔案Laravel
- 動態 SQL、EXECUTE IMMEDIATE、using、into、returningSQL
- oracle 動態語句中的returning用法Oracle
- random 模組random
- Random和Math.random()簡單總結random
- Recipe 5.2. Listing a Table's Columns
- Recipe 5.6. Using SQL to Generate SQLSQL
- Recipe 6.7. Extracting Initials from a Name
- Math.random()random
- Math.randomrandom
- random()函式random函式
- dbms_randomrandom
- 使用 Recipe 安裝 SAP Commerce CloudCloud
- Recipe 3.1. Stacking One Rowset atop Another
- Recipe 4.7. Blocking Inserts to Certain ColumnsBloCAI
- [Laravel] - | Learning records | ORM 模型關聯 with () 用法LaravelORM模型
- 【DBMS_RANDOM】使用 DBMS_RANDOM包生成隨機字串random隨機字串
- Recipe 4.10. Updating with Values from Another Table
- python random模組Pythonrandom
- np.random.choicerandom
- DBMS_RANDOM使用random
- 測試random類random
- different random numbers generatorrandom
- KunlunDB功能之insert/update/delete...returning語句delete
- CodeForces_1422D Returning Home(最短路)
- centos5.4 kernel random number generator_/dev/urandom及/dev/randomCentOSrandomdev
- np.random.multivariate_normal()randomORM
- numpy-random函式random函式
- python_random模組Pythonrandom
- JAVA的Random類(轉)Javarandom
- ORA-28056 Writing audit records to Windows Event Log failedWindowsAI