Re: jBASE 3.4 on Redhat - > TOP X RECORDS or someyhing similar?

[Charlie Noah]

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 jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en