Posted by Hugo Kornelis on 08/16/07 20:23

On Thu, 16 Aug 2007 03:39:49 -0700, WhytheQ wrote:

>This doesn't work:
>
>--****************************************
>USE myDatabase
>SELECT TOP 10 *
>FROM myTable
>WHERE NEWID()
>--****************************************
>
>..I know I need to use the function newID() to find random records -
>just don't know where it fits in the query (suspect the TOP will need
>to go from the above)
>
>Any help greatly appreciated
>J

Hi J,

Marcin's answer is correct. However, if you're on SQL Server 2005 you
can also use the new TABLESAMPLE option (see Books Online for the
details); this will probably perform better on large tables.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

• Next in forum: HELP! Need to find info on AccPac databases! (OT)
• Prev in forum: Re: ODBC Timeout problems but very hard to pin down
• Thread view: Re: SELECT a random 10 records from table....easy newbie question

[Reply to this message]