/ Published in: SQL

Expand |
Embed | Plain Text
SELECT COLUMN, RAND() AS IDX FROM TABLE ORDER BY IDX FETCH FIRST 1 ROWS ONLY
You need to login to post a comment.
jordantbro on 01/21/09
1 person have marked this snippet as a favorite
SELECT COLUMN, RAND() AS IDX FROM TABLE ORDER BY IDX FETCH FIRST 1 ROWS ONLY
You need to login to post a comment.