Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT SQL with SKIP
Message
 
 
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:
00916336
Views:
13
Try
SELECT TOP 40 * ;
  FROM datos ;
  ORDER BY 1 ;
  INTO CURSOR crsTemp NOFILTER
SELECT * ;
  FROM crsTemp ;
  WHERE RECNO() > 30
>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.
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform