So how do you select a random row in a SQL database table?
[codesyntax lang=”sql”]
SELECT TOP 1 Name, Address, City FROMÂ Â Â Â Â Â Â Â tbl_Person ORDER BY NEWID()
[/codesyntax]
This will select a random person every time.
So how do you select a random row in a SQL database table?
[codesyntax lang=”sql”]
SELECT TOP 1 Name, Address, City FROMÂ Â Â Â Â Â Â Â tbl_Person ORDER BY NEWID()
[/codesyntax]
This will select a random person every time.