Home » SQL & PL/SQL » SQL & PL/SQL » Query to rank
Query to rank [message #248312] Thu, 28 June 2007 10:51 Go to next message
mvnrajan
Messages: 5
Registered: June 2007
Junior Member
Hi guys,

Am strugling to write a query. I need output as follows.

I have companyid with duplicates in a table. That table contains
only companyid. For example, only 2 companyid exist in table with duplicates.
Column SEQ has to display as 1 for first companyid and 2 for second companyid.DRANK column has to display a rank corresponding to companyid.

I need a output as follows

Any guys please..........




companyid ID SEQ RANK
----------------------------------------
CH46911 1 1
CH46911 1 2
CH46911 1 3
CH46911 1 4
GB24158 2 1
GB24158 2 2
GB24158 2 3
GB24158 2 4
  • Attachment: aaa.txt
    (Size: 0.26KB, Downloaded 177 times)
Re: Query to rank [message #248314 is a reply to message #248312] Thu, 28 June 2007 11:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select companyid,
       decode(companyid,'CH46911',1,2) id,
       row_number() over(partition by companuid order by rowid) seq
from mytable
/

Regards
Michel
Re: Query to rank [message #248497 is a reply to message #248314] Fri, 29 June 2007 03:50 Go to previous message
mvnrajan
Messages: 5
Registered: June 2007
Junior Member

Your query helped me to solve my problem Michel....

Thanks a lot.......

Cheers........

Regards
Nataraj
Previous Topic: How to spool output of PL/SQL procedure/function to file?
Next Topic: How to detect the special characters in string
Goto Forum:
  


Current Time: Mon Dec 05 19:29:44 CST 2016

Total time taken to generate the page: 0.10671 seconds