Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Last 10 records based on a condition
Message
From
30/12/2001 23:39:29
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00599284
Message ID:
00599300
Views:
31
>< snip >
>>
>>It'd be nice if SELECT FIRST 10 would be supported as well as SELECT LAST 10.
>
>Isn't SELECT TOP 10 the same as SELECT FIRST 10 ?

Yes, I was mostly making reference to the SQL Server syntax.

I had the assumption that the SQL syntax, supported on SQL Server, was grabbing the first records which were meeting the condition without having to select from the entire table first.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform