Number records

[MuLtAnI]

Hello guys, I wonder if anyone knows any way to number the records of a selection without being by the rownum select rownum, cod_pro, desc_pro from cod_pro order by cadpro that way my rowid will come cluttered, because the order by der by cod_pro and if I sort on rownum também cod_pro coming cluttered I need sort the records by cod_pro and assign values sorted the records

Since já thanks!!!!!


Hugs

[dr_gori]

I think you'll have to use a sub-select.
Something like:

Code: Select all

select rownum, a.*
from
  (select b.cod_pro, b.desc_pro
   from cadpro b
   order by b.cod_pro) a


is this?

[MuLtAnI]

I did a selfjoin

Code: Select all

select rownum, b.cdpro
from cadpro a, cadpro b
where a.cdpro = b.cdpro

worked out here ... actually I did that right after I posted in the Forum, because a it was not for me ... to a colleague ... but thanks for the strength!!

[] 's

[leobbg]

Code: Select all

select ., cod_pro b . b desc_pro from cadpro b order by dense_rank over ( ) ( b desc_pro ) . order by

falou! : twisted: