I believe Sami is correct: count starts from the first datum entered and does not go in sorted order, the sort takes place after the count. To do a first 50 values after the sort, create a sorted view, and select where count from the view.
"Sami Aaron" <[EMAIL PROTECTED]> wrote: >Be sure to proof out your results using the COUNT feature if you are also >including an ORDER BY, GROUP BY or have breakpoints set in a report. �You >just might not get the records you thought you were going to get ... > >I can't remember the problem exactly but I think it might not sort before it >does the count ... > >Sami > >Sami Aaron >Software Management Specialists >19312 W 63rd Terr >Shawnee KS �66218 >913-915-1971 � Fax 913-962-9431 >mailto:[EMAIL PROTECTED] > > >----- Original Message ----- >From: "Atrix Wolfe" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, August 13, 2002 3:20 PM >Subject: Re: limiting results from a select > > >> it works...yay! >> >> thanks for your help >> >> ----- Original Message ----- >> From: "Mike Willochell" <[EMAIL PROTECTED]> >> To: <[EMAIL PROTECTED]> >> Sent: Tuesday, August 13, 2002 12:47 PM >> Subject: Re: limiting results from a select >> >> >> > Try ...COUNT > 50 >> > >> > At 12:34 PM 8/13/2002 -0700, you wrote: >> > >I know in R:Base you are allowed to say limit=100 to of course limit >the >> > >result to 100. �I was wondering however if theres a way to say >something >> > >like start=50 so that it would ignore the first 50 results? >> > >> > ================================================ >> > TO SEE MESSAGE POSTING GUIDELINES: >> > Send a plain text email to [EMAIL PROTECTED] >> > In the message body, put just two words: INTRO rbase-l >> > ================================================ >> > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >> > In the message body, put just two words: UNSUBSCRIBE rbase-l >> > ================================================ >> > TO SEARCH ARCHIVES: >> > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
