Select Random Row, SQL Server
DZone's Guide to
Select Random Row, SQL Server
by
·
Join the DZone community and get the full member experience.
Join For Free// select a random row in SQL Server, apparently. Untested.
SELECT TOP 1 column FROM table
ORDER BY NEWID()
Like This Article? Read More From DZone
Topics:
Opinions expressed by DZone contributors are their own.
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}