Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to select x number of rows
Message
From
12/08/2010 22:06:59
Naomi Nosonovsky
Wisconsin, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: How to select x number of rows
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01476406
Message ID:
01476423
Views:
40
>>I see - in this case I suggest:
>>
>>select T.myFields from myTable T inner join (select top N PkField from myTable
>> where myCondition order by myField) X on T.PkField = X.PkField
>
>Thanks

It may or may not help.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform