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:

> 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 au
Received on Thu Jan 28 2010 - 17:01:20 CST

Original text of this message