I'm hoping someone can help me with a technique to add a rownumber in a different way to the simple use of it.
I have a data table that looks like this Subject Name Grade English Tom A English Paul A English James B Maths Tom B Maths Paul D Maths James A Science Tom C Science Paul D I want to add a rownumber that restarts on each new subject - here is a sample how I am trying to get ther results. Subject RowNumber Name Grade English 1 Tom A English 2 Paul A English 3 James B Maths 1 Tom B Maths 2 Paul D Maths 3 James A Science 1 Tom C Science 2 Paul D TIA --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
