/ Published in: SQL
MS SQL Select a Random Row with NEWID()
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
SELECT TOP 10 PERCENT * FROM tablename ORDER BY NEWID()
SELECT TOP 10 PERCENT * FROM tablename ORDER BY NEWID()