Re: find position of row in set of rows
From: Tim X <timx_at_nospam.dev.null>
Date: Fri, 29 Jan 2010 10:01:20 +1100
Message-ID: <87bpgd96m7.fsf_at_lion.rapttech.com.au>
cate <catebekensail_at_yahoo.com> writes:
Date: Fri, 29 Jan 2010 10:01:20 +1100
Message-ID: <87bpgd96m7.fsf_at_lion.rapttech.com.au>
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?
Tim
-- tcross (at) rapttech dot com dot auReceived on Thu Jan 28 2010 - 17:01:20 CST