SELECT TOP 1 * FROM Table WHERE SomeColumn = something ORDER BY NEWID()ACCESS
SELECT TOP 1 * FROM Table WHERE SomeColumn = something ORDER BY RND(ColumnName)MySQL
SELECT * FROM Table ORDER BY RAND() LIMIT 1Oracle
SELECT * FROM (SELECT * FROM Table ORDER BY dbms_random.value) WHERE rownum = 1;