Help with ROW_COUNT()
From: <sw_at_weinerfamily.org>
Date: Mon, 04 Dec 2000 15:12:09 GMT
Message-ID: <3A2BB41B.12EA754D_at_weinerfamily.org>
Date: Mon, 04 Dec 2000 15:12:09 GMT
Message-ID: <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 - 16:12:09 CET