Posted by Marcin A. Guzowski on 08/16/07 11:17

WhytheQ pisze:
> 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

Replace "WHERE" with "ORDER BY":

SELECT TOP 10 *
FROM myTable
ORDER BY NEWID()

IMHO this query won't be efficient against large tables.


--
Best regards,
Marcin Guzowski
http://guzowski.info

• Next in forum: Re: wants sql query
• Prev in forum: Re: Creating database from stored proc with variable holding the database name
• Thread view: Re: SELECT a random 10 records from table....easy newbie question

[Reply to this message]