RE: how to do a random ORDER BY in a SELECT statement

TED] Sent: Wednesday, September 10, 2003 8:05 PM To: [EMAIL PROTECTED] Subject: how to do a random ORDER BY in a SELECT statement I am querying a table and using the following statement: SELECT * FROM financial_affiliates WHERE state = 'wa' AND category = '3' ORDER BY name I would li

Re: how to do a random ORDER BY in a SELECT statement

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Doug, et al -- ...and then David T-G said... % % ...and then Comcast said... % % % % I would like to ORDER BY RANDOM - is there an easy way to do that. % ... % I don't know if you can select random() like you can select count() but % perhaps you d

Re: how to do a random ORDER BY in a SELECT statement

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Doug -- ...and then Comcast said... % % I am querying a table and using the following statement: % % SELECT * FROM financial_affiliates WHERE state = 'wa' AND category = '3' ORDER BY name % % I would like to ORDER BY RANDOM - is there an easy way

how to do a random ORDER BY in a SELECT statement

I am querying a table and using the following statement: SELECT * FROM financial_affiliates WHERE state = 'wa' AND category = '3' ORDER BY name I would like to ORDER BY RANDOM - is there an easy way to do that. Thanks. -Doug