Well I just found something cool as I was looking for a way to select some data from a SQL Server table and only return 1 random row. Pretty easy too:

SELECT TOP 1 columnName FROM table ORDER BY NEWID()

Works like a charm.

Popularity: 61% [?]