Re: 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.

Comment on Re: Ranking position in a SQL index Download Code

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]


laziness, impatience, and hubris
	PerlMonks