Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT SQL with SKIP
Message
From
23/06/2004 08:04:38
 
 
To
23/06/2004 07:12:45
Ignacio Amoros
Juguetes Pastor, S.L.
Altea, Spain
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00916329
Message ID:
00916344
Views:
14

Hi all!

I've the next problem:

I need to do a query as this:

SELECT TOP 10 SKIP 30 * FROM datos ORDER BY 1

In other words

I choose the first 10 records but the group must be init at record 31.
Can help me?

Sorry for my english


the record 31 is the 31° ordered record or the 31° original record ?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform