Posts by Dihonn Silva • 1 point
1 post
-
-1
votes4
answers38774
viewsA: Sequential numbering of query results
For oracle I resolved as follows: with test as ( SELECT field1, peasant 2 FROM table ORDER BY campo1 ) SELECT ROWNUM AS SEQ, test. * FROM test;