Re: Number inside SQL Statement like ROWNUM

From: Richard Kuhler <noone_at_nowhere.com>
Date: Wed, 06 Mar 2002 22:10:42 GMT
Message-ID: <Ctwh8.9020$Gu6.4523865@typhoon.san.rr.com>

select primary_key,
  foreign_key_1,
  dense_rank() over (
    partition by foreign_key_1
    order by foreign_key_1, primary_key) from ...

note: dense_rank() is version 8i or above.

Richard

Stephan Hartmann wrote:
>
> Hello,
>
> i have a table with the following structure
>
> Primary_KEY
> Foreign_KEY_1
> Colour
>
> with Data like
>
> PK FK1 Colour
> 1 500 blue
> 2 500 red
> 3 500 green
> 4 501 blue
> 5 501 yellow
> 6 503 black
>
> i need a result with a number (count) , depending from FK1
>
> PK FK1 Colour Number
> 1 500 blue 1
> 2 500 red 2
> 3 500 green 3
> 4 501 blue 1
> 5 501 yellow 2
> 6 503 black 1
>
> Who can help me?
>
> bye
> Stephan
Received on Wed Mar 06 2002 - 16:10:42 CST