How to get records in random order from a sql query in sql server?

In SQL Server we can get records in random order from a sql query using NEWID() Function like:

SELECT Subject FROM dbo.forumThreads ORDER BY NEWID()

3 comments:

  1. I'm not sure why but this weblog is loading incredibly slow for me. Is anyone else having this problem or is it a issue on my end? I'll
    check back later on and see if the problem still exists.


    My web blog - chapter 13 bankruptcy florida

    ReplyDelete
  2. For newest information you have to pay a quick visit world wide web and on world-wide-web I found this site as a most excellent site for most recent updates.


    Feel free to visit my webpage: The Easy Way to Set Up Your Website

    ReplyDelete

Type more interview question answer here