• Koen Verbeeck (10/10/2014)


    balasundar.sp (10/10/2014)


    Koen, i am not very familiar with windowing functions. If you could give me the select query would be of great help..

    You should see this as an opportunity to learn.

    Why don't you give it a try first and then come back with specific questions, instead of going for the pre-chewed solution?

    HINT: Reading the already posted solutions might prove to be helpful!

    😎