Data Management

SQL Question: Pivots, Analytics and the judicious use of Row_Number()


A few days ago I answered a question from brat about converting 1 field into multiple rows. We solved that question but now we want to handle multiple rows in our source table.


Just a note of warning. This article will really make a lot more sense if you follow along in SQL*Plus, TOAD or some other tool and if you run through the other article first.


0 comments

Editor's Picks