Skip to navigation
Get random rows from mssql table
08.10.19
Select a random row with MySQL: SELECT column FROM table ORDER BY RAND() LIMIT 1 Select a random row with PostgreSQL: SELECT column FROM table ORDER BY RANDOM() LIMIT 1 Select a random row with Microsoft SQL Server: SELECT TOP 1 column FROM table ORDER BY NEWID()
https://stackoverflow.com/questions/19412/how-to-request-a-random-row-in-sql
Reply
Anonymous
Information Epoch 1732624470
Save trees.
Home
Notebook
Contact us
