RE: SQL Question

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
previous company.

Interesting. I just looked through that thread, and it looks like you got
no reply to the final question. Wouldn't a change in ORDER BY help? Not
random, I realize, but may be able to mix things up a bit?

Or maybe (untested) :
T1 AS (SELECT Status, (rand() * 10000) as rndnum, InfoField, ROW_NUMBER()
over ...
...
... ORDER BY RNDNUM



To recap, here's your message and question:

Elvis

Thanks for pointing me in the right direction.

After doing it the hard way, this worked for me;

With T1 AS (SELECT Status,
InfoField,
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?

Dennis Lovelady
--
"I knew I was an unwanted baby when I saw that my bath toys were a toaster
and a radio."
-- Joan Rivers