Re: find position of row in set of rows
Date: Fri, 29 Jan 2010 10:01:20 +1100
cate <catebekensail_at_yahoo.com> 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 auReceived on Thu Jan 28 2010 - 17:01:20 CST