Picking a random row from the table

Madhu.b.rokkam
Posted by Madhu.b.rokkam under Sql Server category on | Points: 40 | Views : 1949
Select top 1 * from tableName order by NEWID()

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

Comments or Responses

Login to post response