Monday, August 9, 2010

Random Rows

Here's an easy way to select a random row from a table:

SELECT TOP 1 * FROM Test4 ORDER BY NEWID()
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)