If I understand your question correctly you want to group results for
statistical analysis. For instance if you have 2000 results (sequenced in
some way) you want to be able to split those results into 10 equal (or
nearly equal) groups of results and re-aggregate your results based on the
new "
João Borsoi Soares <[EMAIL PROTECTED]> wrote on 23/11/2004
12:34:01:
> First thanks for the answer Alec. But I think you didn't understood my
> problem. Maybe nobody replied because of that. Let me try again.
>
> Suppose I make a select which returns 100 ordered rows. I only want to
> read rows
First thanks for the answer Alec. But I think you didn't understood my
problem. Maybe nobody replied because of that. Let me try again.
Suppose I make a select which returns 100 ordered rows. I only want to
read rows number 10, 20, 30, 40, 50, 60, 70, 80, 90 and 100.
To read the 10th row I would
I think the reason nobody has replied is that the term "row number" does
not really have any meaning in a DBMS. How the database stores rows
inteneally is the DBMS's private business, and should not be visible to
you. I think it is true that MySQL does not *have* an internal row number,
so ther
No body has answered my question so far. Does that mean there is no way
to retrieve current row numbers in a query or no way to retrieve results
jumping steps?
I would appreciate any help.
Thanks,
Joao.
-Mensagem encaminhada-
> From: João Borsoi Soares <[EMAIL PROTECTED]>
> To: [EMAIL PR