Thursday, July 06, 2006

SQL 2000 How to get a random row from a database


SELECT TOP 10 City, NewID() as Random
FROM dbo.Customers
ORDER BY Random

No comments: