Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT TOP ???
Message
From
25/07/2000 12:31:48
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00396652
Message ID:
00396657
Views:
8
TOP x determines the TOP x values, not record.
In this case, the TOP 1 value for DESCRIP is "", and 8 records match this value.
If the TOP 2 were "", and "ABC" and 40 records have DESCRIP="ABC", 48 records will be returned.
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform