Thread: Select a row at random?
View Single Post
  #5 (permalink)  
Old 12-17-2006, 11:02 PM
Hank Swart
 
Posts: n/a
Default MS SQL answer. Re: Select a row at random?
[sql]
SET ROWCOUNT 1

SELECT
NEWID() AS [RANDOM],
PROJECT,
SITE_ID,
SAMPLE_ID
FROM
GB_SAMPLE
ORDER BY
[RANDOM] ASC

SET ROWCOUNT 0
[/sql]
Reply With Quote