Subject | Re: [firebird-support] select every nth row |
---|---|
Author | Helen Borrie |
Post date | 2009-04-21T10:07:42Z |
At 06:55 PM 21/04/2009, you wrote:
./hb
>If you really want to do this you can, as follows:Nope. It will give you all the rows in the set (in this example, the whole table) except the first 10.
>select skip skipvalue yourdata from yourtable
>
>e.g. this will give you every 10th row.
>select skip 10 id, value1, value2 from bigtable
./hb