Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with ROW_COUNT()
If you want to use row_number, you have to code:
select * from (
select pkey, value, row_number() over (order by ........) as valcol
from table1)
where valcol = 5
Klaus
<sw_at_weinerfamily.org> schrieb in im Newsbeitrag:
3A2BB41B.12EA754D_at_weinerfamily.org...
> I need to find the 5th row in a selection, ordered by a value column.
> Since ROWNUM takes affect after the rownum is assigned it won't work.
> So I tried using ROW_NUMBER(). However the following query doesn't
> work:
>
> SELECT pkey, value,
> ROW_NUMBER() over (ORDER BY value ASC NULLS LAST) AS valcol
> FROM table1
> WHERE valcol = 3
>
>
>
Received on Mon Dec 04 2000 - 12:16:38 CST