Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select question
Message
From
19/01/2001 13:02:27
 
 
To
19/01/2001 12:50:54
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00465848
Message ID:
00465858
Views:
11
>>ok.. I know you can get the top 10 records by using "Select top 10 from table"
>>
>>but I don't see the inverse of that in any documentation anywhere.. Something like "Select bottom 10 from table"
>>
>>How do I do this? TIA!!
>All you will need to do is to use descending order and select top 10 again which in fact are bottom 10 now.
>Mark

Doh! I knew that.. temporary brain damage I guess.. Thanks tho, it worked like a charm. ; )
Previous
Reply
Map
View

Click here to load this message in the networking platform