select top 500 Comment from ( select top 5000 Comment fro...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 500 Comment
from (
  select top 5000 Comment
  from ReviewTaskResults
  where ReviewTaskResultTypeId=3
  and Comment is not null
  and CreationDate > getdate()-120
  order by newid()
) x

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results