Re: find position of row in set of rows

From: Tim X <>
Date: Fri, 29 Jan 2010 10:01:20 +1100
Message-ID: <>

cate <> writes:

> I have a table ordered by date. When I find a specific record in this
> set, I want to know what its position is in this ordered list.
> I could get the date from the record found and count dates above or
> below, but is there a better way?
> Thank you.

the rownum pseudo column?


tcross (at) rapttech dot com dot au
Received on Thu Jan 28 2010 - 17:01:20 CST

Original text of this message