Reset ROWNUM and Suppress Repeating Groups

(Satyanarayana Josyula) You can reset the serial numbers after each group break using a single query–without using any utilities. This technique uses the ROWNUM returned by Oracle and resets the serial number at the beginning of each group. Also this query shows how to suppress the repeating gr

Read More - Register for Free Membership