Subject Re: [firebird-support] select every nth row
Author Helen Borrie
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