would adding "and limit = 1" do the trick? It isn't quite random because I believe it would always select the first physical row that matches the where clause.
Karen -----Original Message----- From: Dan Goldberg <[email protected]> To: rbase-l <[email protected]> Sent: Tue, Aug 9, 2016 12:06 pm Subject: [RBASE-L] - pick a random row I have a select statement that I need to create that will pick one random row based on the where clause. SELECT *FROM averyweb_items WHERE iditemscategory = 4 AND itemsstatus = 1 I can do a random function but not sure on how to implement it. I cannot figure out what I need to do. Any help is appreciated. TIA Dan Goldberg MIS Manager Lance Camper Mfg. Corp (661) 949-3322 Ext 252 www.lancecamper.com -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
