× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.