UtterAccess.com
Thank you for your support!      
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Randomly select rows by category    
 
   
atrox
post Oct 30 2009, 11:09 AM
Post #1

New Member
Posts: 4
I have a table from which I need to randomly select rows. In the table, I have a category called "Ind" which has about 100 individual values in it and I need to select 3 rows from each of these individual values- so, in the end, about 300 rows should be randomly selected from the entire table. Can anyone help with how to code for this (I am somewhat new to SQL).
Go to the top of the page
 
+

Posts in this topic
- atrox   Randomly select rows by category   Oct 30 2009, 11:09 AM
- - debra_dixon   Re: Randomly select rows by category   Oct 30 2009, 12:13 PM
- - atrox   Re: Randomly select rows by category   Oct 30 2009, 01:29 PM
- - debra_dixon   Re: Randomly select rows by category   Oct 30 2009, 01:58 PM
- - atrox   Re: Randomly select rows by category   Oct 30 2009, 02:10 PM
- - debra_dixon   Re: Randomly select rows by category   Oct 30 2009, 02:22 PM
- - orange999   Re: Randomly select rows by category   Oct 31 2009, 10:47 AM
- - GroverParkGeorge   Re: Randomly select rows by category   Oct 31 2009, 02:39 PM
- - RickGirn   Re: Randomly select rows by category   Nov 1 2009, 01:14 AM
- - GroverParkGeorge   Re: Randomly select rows by category   Nov 1 2009, 02:02 AM
- - orange999   Re: Randomly select rows by category   Nov 1 2009, 03:22 PM
- - GroverParkGeorge   Re: Randomly select rows by category   Nov 1 2009, 04:12 PM
- - atrox   Re: Randomly select rows by category   Nov 1 2009, 04:57 PM

« Next Oldest · Access Tables + Relationships · Next Newest »
 

Reply to this topicStart new topic

 

Display Mode: Switch to: Standard · Switch to: Linear+ · Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 4th February 2012 - 11:22 PM