Suppress Repeating Groups Using RANK (not ROWNUM)

(Mohammad Anwar) This tip achieves the same output as the Tip for Week of August 23, 2004. In that tip, the author uses ROWNUM and inline views, whereas I use the analytic function RANK() to do the job.

Read More - Register for Free Membership