main logo
Subject: Re: [NF] Equivalent of "Select TOP N" in Oracle?
Author: Ed Leafe
Posted: 2004/11/30 21:14:21
 
View Entire Thread
New Search


On Nov 30, 2004, at 7:41 PM, Bill Arnold wrote:

> BTW, one of the mysteries of VFP is that when you SELECT TOP 3, you can
> get a bunch more records in the result set than 3, if they have
> matching
> values in the ORDER BY field. I think that's wrong.

So if there are 2,000,000 records that match your criteria, how do you
determine which are the top 3?

___/
/
__/
/
____/
Ed Leafe
http://leafe.com/
http://dabodev.com/



 
©2004 Ed Leafe
<-- Prior Message New Search Next Message -->