Hello everyone, I wonder if anyone knows any way to number the records of a selection without being by Rownum
Select Rownum, COD_PRO, CADPRO Order by cod_pro
99] This way my rowid will come cluttered, due to the order by d der by cod_pro and if I sort by the rownum também the cod_pro will come cluttered
I need to order the records by cod_pro and Assign values ??ordered to records ..
from já thank you !!!!!
Hugs
Number
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
I think you'll have to use a sub-select ...
Something like:
Is this?
Something like:
select rownum, a.*
from
(select b.cod_pro, b.desc_pro
from cadpro b
order by b.cod_pro) a
I did a selfjoin
worked here ... Actually I did it shortly after I posted in the forum, because it was not even for me .. .Prise a colleague ...
But thanks for the force !!
[] 's
select rownum, b.cdpro
from cadpro a, cadpro b
where a.cdpro = b.cdpro
But thanks for the force !!
[] 's
-
- Information
-
Who is online
Users browsing this forum: No registered users and 10 guests