隨機取出資料表中資料

語法類型：T-SQL

使用時機：當需要隨機取出資料表中的資料時

解決方案：

ACCESS: 
SELECT TOP 1 * FROM Table ORDER BY RND(column) 

MySQL: 
SELECT column FROM table ORDER BY RAND() LIMIT 1 

PostgreSQL: 
SELECT column FROM table ORDER BY RANDOM() LIMIT 1 

Microsoft SQL Server: 
SELECT TOP 1 column FROM table ORDER BY NEWID() 

IBM DB2: 
SELECT column FROM table ORDER BY RAND() FETCH FIRST 1 ROWS ONLY 

Oracle: 
SELECT column FROM 
( SELECT column FROM table 
ORDER BY dbms_random.value ) 
WHERE rownum = 1 
or 
SELECT * sample(1) FROM table WHERE .... 
or 
NO WHERE CLAUSE, 10%: 
SELECT * FROM table sample(10)