Thread: Select a row at random?
View Single Post
  #6 (permalink)  
Old 12-17-2006, 11:04 PM
Hank Swart
 
Posts: n/a
Default MS SQL answer. Re: Select a row at random?
[sql]
SELECT TOP 1
NEWID() AS [RANDOM],
PROJECT,
SITE_ID,
SAMPLE_ID
FROM
GB_SAMPLE
ORDER BY
[RANDOM] ASC
[/sql]
Reply With Quote