Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2008
    Posts
    94

    Unanswered: What is DB2 RowNumber() Equivalent in Oracle?

    I have a join query.
    Suppose i have customer ID,Name.
    I have to find the Duplicate for ID and Name with rownumber.
    Same like DB2 Rownumber() Over (Partition by ID,Name).

    what is equivalent solution in Oracle.

  2. #2
    Join Date
    Dec 2007
    Posts
    253
    Surely it's not that difficult to have a quick look at the documentation?
    Read the Fine Manual

  3. #3
    Join Date
    Jul 2008
    Posts
    94
    Thank you pablolee.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •