Re: [Fwd: row numbers, jumping rows]

2004-11-23 Thread SGreen
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 "

Re: [Fwd: row numbers, jumping rows]

2004-11-23 Thread Alec . Cawley
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

Re: [Fwd: row numbers, jumping rows]

2004-11-23 Thread João Borsoi Soares
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

Re: [Fwd: row numbers, jumping rows]

2004-11-23 Thread Alec . Cawley
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

[Fwd: row numbers, jumping rows]

2004-11-23 Thread João Borsoi Soares
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