Picking a random row from the table

Select top 1 * from tableName order by NEWID()

This will return a randow row data from the given table.