syntax for Proc Sql to get row_number() in Oracle
Posted on 2014-03-24
Can someone tell me the syntax to get the row_number reading in Oracle table using SQL.
I have about 50 columns in the select, and I know there is a way, but I can' remember the exact syntax.
It looks something like
SELECT T1.member_id, ROW_NUMBER() OVER (ORDER BY T1.member_id) AS ROWNUM FROM
(Select fielda, fieldb, fieldc etc.
It is the second select that has all the fields, the first select just had the fields for ordering.