SELECT * FROM some_table ORDER BY RAND() LIMIT 1
SELECT top 1 word FROM dictionary ORDER BY rand(checksum(word + convert(varchar(23),getdate(),21)))
SELECT COLUMN FROM TABLE ORDER BY RANDOM() LIMIT 1
SET ROWCOUNT 1 SELECT NEWID() AS [RANDOM], PROJECT, SITE_ID, SAMPLE_ID FROM GB_SAMPLE ORDER BY [RANDOM] ASC SET ROWCOUNT 0
SELECT TOP 1 NEWID() AS [RANDOM], PROJECT, SITE_ID, SAMPLE_ID FROM GB_SAMPLE ORDER BY [RANDOM] ASC
SELECT * FROM YourTable ORDER BY NewId()
ANY dialect question:
