How about WHERE COUNT > 49? or
WHERE COUNT BETWEEN 50 and 99? Create a view to sort your dataset and then use the count clause in the select on the view. -- Dennis McGrath mailto:[EMAIL PROTECTED] -- Tools for R:BASE programmers http://www.enteract.com/~mcgrath/dennis -- Full time consultant with SQL Resources mailto:[EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Atrix Wolfe Sent: Tuesday, August 13, 2002 2:34 PM To: [EMAIL PROTECTED] Subject: limiting results from a select 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/
