User Profile

Collapse

Profile Sidebar

Collapse
Dharmendra patel
Dharmendra patel
Last Activity: Aug 23 '07, 08:45 AM
Joined: Aug 12 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Dharmendra patel
    replied to Help In query
    in Oracle
    -----------------------
    Hi Amit

    it is not fullfill my need. I want order of repcol based on values present for rank 1.

    Thanks for try.


    Regards,
    Dharmendra...
    See more | Go to post

      Leave a comment:

    • Dharmendra patel
      started a topic Help In query
      in Oracle

      Help In query

      Dear All ,

      I have one query which give below result.
      > select repcol,value,ra nk() over ( partition by repcol

      2 order by value desc ) ranked_value

      3 from test;



      REPCOL VALUE RANKED_VALUE

      ---------- ---------- ------------

      A 500 1

      A 300...
      See more | Go to post
      No activity results to display
      Show More
      Working...