RE: can I take the record's number?

2002-03-03 Thread Roger Baklund
* Nikolas > The problem with LIMIT is that this table is not the same always, the > ordering depends on data that changes. > > I am ordering a table that contains webpages by the number of times they > have been visited. Then, for a specific page of them, I want to say in > which position of po

Re: can I take the record's number?

2002-03-03 Thread Nikolas
The problem with LIMIT is that this table is not the same always, the ordering depends on data that changes. I am ordering a table that contains webpages by the number of times they have been visited. Then, for a specific page of them, I want to say in which position of popularity it is. I thi

RE: can I take the record's number?

2002-03-03 Thread Roger Baklund
* Nikolas > If I have a table ordered by something, is it possible to select fields > from a record that appears on the table in a specific row number. > And if yes, how can I do it? > > By row number, I mean that if the table has 10 records, I want to select > something from the record that is i

can I take the record's number?

2002-03-03 Thread Nikolas
I am novice in SQL so I may ask something very obvious, sorry. If I have a table ordered by something, is it possible to select fields from a record that appears on the table in a specific row number. And if yes, how can I do it? By row number, I mean that if the table has 10 records, I want t