What about right a program called TOP. That program would execute the SELECT and then return the first N records specified as an option as an active select list to the calling program?
On Tue, Feb 17, 2009 at 2:27 PM, ww <w...@waltwhite.com> wrote: > > Tony, > > You're correct. The only way I can think to do it is SELECT in > decending order and SAMPLE 10 from the results. > > Thanks. > > On Feb 17, 1:55 pm, "Tony G" <e09kp5...@sneakemail.com> wrote: > > I believe SAMPLE will select a sampling of N records from the > > file and then perform the query, where the SQL TOP specification > > will return the top N records after the query has been run. So > > SAMPLE would be used to test queries before they go production > > and TOP is used to provide a specific kind of production report. > > No? > > > > T > > > > > > > > > From: Jim Idle > > > ww wrote: > > > > Is there such a command in jBase? > > > > > LIST FILE SAMPLE 5- Hide quoted text - > > > > - Show quoted text - > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---