in reply to Ranking position in a SQL index

Are you looking for something like a Oracle's implied column rownum? You know ... 
select what, ever, rownum RANK from something where rownum between 123
+ and 321;

[download]
... my SQL and Oracle are rusty but I hope you find that helpful.

Plankton: 1% Evil, 99% Hot Gas.

Replies are listed 'Best First'.
Re^2: Ranking position in a SQL index
by jplindstrom (Monsignor) on Oct 05, 2004 at 11:23 UTC
    Actually rownum doesn't work quite like that.

    Tom has a good explanation of what it does. It could be useful in the original poster's case though.

    /J

[reply]

In Section Seekers of Perl Wisdom