How to request a random row in SQL?

Question

How can I request a random row (or as close to truly random as is possible) in pure SQL?

Answer 1

Select @rowcnt = max(id) from TableName

Set @rowID = ceiling(rand(convert(varbinary, newid())) * @rowcnt)

Select top 1 * from TableName where id >= @rowID order by id asc