On Jul 4, 6:43 pm, Vlad <vladimir.mcbad...@gmail.com> wrote:
> 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
Analytics are your friend with this one (presuming your instructor has
covered them). What have you done to solve this problem? Where is
the query you've written, that obviously does not work? Post your
efforts and we'll help you, but we won't do your homework for you.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
