隨機取得資料(MSSQL,ACCESS,MYSQL)

MySQL︰

view plaincopy to clipboardprint?

1. SELECT column_name  
2. FROM table_name 
3. ORDER BY RAND() 
4. LIMIT 1 

SELECT column_name 
FROM table_name
ORDER BY RAND()
LIMIT 1
PostgreSQL︰

view plaincopy to clipboardprint?

1. SELECT column_name FROM table_name 
2. ORDER BY RANDOM() 
3. LIMIT 1 

SELECT column_name FROM table_name
ORDER BY RANDOM()
LIMIT 1
Microsoft SQL Server︰

view plaincopy to clipboardprint?

1. SELECT TOP 1 column_name FROM table_name 
2. ORDER BY NEWID() 

SELECT TOP 1 column_name FROM table_name
ORDER BY NEWID()
Oracle︰

view plaincopy to clipboardprint?

1. SELECT column_name FROM
2. ( SELECT column_name  
3. FROM table_name  
4. ORDER BY dbms_random.value ) 
5. WHERE rownum = 1 

SELECT column_name FROM
(SELECT column_name
FROM table_name 
ORDER BY dbms_random.value )
WHERE rownum = 1
IBM DB2︰

view plaincopy to clipboardprint?

1. SELECT column_name, RAND() as IDX 
2. FROM table_name 
3. ORDER BY IDX FETCH FIRST 1 ROWS ONLY

SELECT column_name, RAND() as IDX
FROM table_name
ORDER BY IDX FETCH FIRST 1 ROWS ONLY
引用http://ianjung1974.blogspot.com/search/label/DB%20%2F%20SQL