Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT SQL with SKIP
Message
From
23/06/2004 07:49:21
Fabian Belo
Independent Developer
Argentina
 
 
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:
00916337
Views:
17
Hi Ignacio;

I think it can't be done unless you use 2 queries.

>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
"Since I've read that alcohol is bad... I quit reading."
Me


http://www.fabianbelo.com.ar
Previous
Reply
Map
View

Click here to load this message in the networking platform