SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Row number by group of records

3068783Nov 24 2015 — edited Nov 25 2015

Hi.

I need to createfunction to check value of row below and if there will be the same value in specified column then display nothing else I wan't to display counted number of records with the same value.

Short verstion.

I want to display:

record_1 3

record_1

record_2 3

record_2

record_3 1

insted of:

record_1 3

record_2 3

record_3 1

Is there someone who could help me ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 23 2015

Added on Nov 24 2015

18 comments

15,801 views