SQL 隨機取一筆

SQL Server 2005

SELECT TOP 1 Field1, …, FieldN
FROM Table1
ORDER BY NEWID()

Access

SELECT TOP 1 Field1 , …, FieldN
FROM Table1
ORDER BY Rnd(Field1)

MySQL

SELECT Field1, …, FieldN
FROM Table1
ORDER BY RAND()
LIMIT 1

Oracle 10g Express

SELECT Field1, …, FieldN
FROM ( SELECT Field1, …, FieldN
FROM Table1
ORDER BY dbms_random.value)
WHERE rownum <= 1

SQLite 3

SELECT Field1, …, Field2
FROM Table1
ORDER BY Random()
LIMIT 1

PostgreSQL 8.3

SELECT “Field1″, “…”, “FieldN”
FROM “Table1″
ORDER BY RANDOM()
LIMIT 1