Just as well I've never tried anything like that, then!
Red faces all round.
--
Alan J Davies
Aldis



Quoting Helen Borrie <helebor@...>:

> At 06:55 PM 21/04/2009, you wrote:
>> If you really want to do this you can, as follows:
>> select skip skipvalue yourdata from yourtable
>>
>> e.g. this will give you every 10th row.
>> select skip 10 id, value1, value2 from bigtable
>
> Nope. It will give you all the rows in the set (in this example,
> the whole table) except the first 10.
>
> ./hb
>
>