MySQL︰
view plaincopy to clipboardprint?
- SELECT column_name
- FROM table_name
- ORDER BY RAND()
- LIMIT 1
SELECT column_name
FROM table_name
ORDER BY RAND()
LIMIT 1
PostgreSQL︰
view plaincopy to clipboardprint?
- SELECT column_name FROM table_name
- ORDER BY RANDOM()
- LIMIT 1
SELECT column_name FROM table_name
ORDER BY RANDOM()
LIMIT 1
Microsoft SQL Server︰
view plaincopy to clipboardprint?
- SELECT TOP 1 column_name FROM table_name
- ORDER BY NEWID()
SELECT TOP 1 column_name FROM table_name
ORDER BY NEWID()
Oracle︰
view plaincopy to clipboardprint?
- SELECT column_name FROM
- ( SELECT column_name
- FROM table_name
- ORDER BY dbms_random.value )
- 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?
- SELECT column_name, RAND() as IDX
- FROM table_name
- 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
0 意見:
張貼留言