I was looking for a way to select a random row from a table, preferably in a stored procedure.
This is the query:
SELECT TOP (1) *
FROM table
ORDER BY NEWID()
Simple and effective!
Subscribe to:
Post Comments (Atom)
This blog is about the website I am creating, Kids-n-Fun.com. I am building this site to learn asp.net 2.0, learning how to get this site a high position in the major search engine, in an as short as possible periode.
No comments:
Post a Comment