I asked a very similar question a while back. It may help you get to
the random result set you need. Mine was for some auditors at a
Thanks for pointing me in the right direction.
After doing it the hard way, this worked for me;
With T1 AS (SELECT Status,
ROW_NUMBER() over (PARTITION BY Status ORDER BY Status) as Nbr from
FileName ORDER BY Status )
SELECT * FROM T1 WHERE Nbr < 6
Any thoughts on how to get a random 5 selected instead of the first 5?