Charlie, Performing the two steps you suggested does what I need. I did have to split the two commands as you suspected.
Thank you. P.S. VK, I had the same experience using SAMPLE 100 which returns 100 random records. Issuing the "SELECT file BY-DSND TOTAL.PRICE" first was trick. On Nov 10, 12:53 am, VK <[email protected]> wrote: > Hi, > as my experience shows, if you just "SELECT file BY-DSND TOTAL.PRICE > SAMPLE 100", it will take any 100 records and then sorts them. If you > "SELECT .. BY DSND" first, that might really do the trick. > > VK > > On Nov 10, 1:18 am, Charlie Noah <[email protected]> wrote: > > > > > > > > > WW, > > Try > > SELECT file BY-DSND TOTAL.PRICE SAMPLE 100 > > You might have to split it into 2 commands if Jbase does the sample first: > > SELECT file BY-DSND TOTAL.PRICE SELECT file SAMPLE 100 > > Regards, > > Charlie Noah > > > Tiny Bear's Wild Bird Store > > "Everything For The Backyard Bird Enthusiast, Except For The Birds" > > Info, Forum: http://www.TinyBearMarketing.com > > Store: http://Stores.TinyBearMarketing.com > > On 11-09-2011 4:52 PM, wsw wrote:Is there a english command to select the > > top 100 records because I can't find it I have an attribute TOTAL.PRICE and > > I want to select the top 100 records highest to lowest. Thanks in advance, > > WW -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
