ENGLISH version of SQL TOP command?

2009-02-17 Thread ww
Is there such a command in jBase? 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

Re: ENGLISH version of SQL TOP command?

2009-02-17 Thread Jim Idle
ww wrote: Is there such a command in jBase? LIST FILE SAMPLE 5 Jim --~--~-~--~~~---~--~~ 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

Re: ENGLISH version of SQL TOP command?

2009-02-17 Thread ww
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

Re: ENGLISH version of SQL TOP command?

2009-02-17 Thread Dick Thiot
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

Re: ENGLISH version of SQL TOP command?

2009-02-17 Thread Jim Idle
ww 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. Perform the selection first, then perform the LIST using the generated SELECT list as input. Jim Thanks. On Feb 17, 1:55pm, "Tony G"