Posted by KenJ on 10/01/91 11:39

Hi ja,

To randomize your result set, you can order by newID(), like this...
SELECT TOP 25 * FROM sysdatabases
ORDER BY newID()

• Next in forum: Re: How do I NTH Select in SQL????
• Prev in forum: How do I NTH Select in SQL????
• Thread view: Re: How do I NTH Select in SQL????

[Reply to this message]