Dear all,



In following sql rownum display the row_id where the record is found;



Select histroy_id, rownum from cust_history



output



histroy_id rownum

----------------------------

5 20

8 30

9 33



How can I select row in incremental order so for id = 5 rownum = 1 and
so on for id=8 rownum = 2 etc?

For me is not important to have rownum as they are in table I need to
have them as index 1, 2 , 3, 4 , 5 for each record from history_id.



Thanks



________________________________________
Dritan TABAKU






Oracle LazyDBA home page