Re: HELP

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Tue, 11 Jun 2002 16:22:41 +0600
Message-ID: <ae4j1f$3rv72$1@ID-127142.news.dfncis.de>

Hi,
draw your attention on RANK function. However it depends on your Oracle version.

Regards,Roman Mirzaitov
Brainbench MVP for Oracle Administration www.brainbench.com

"WKC" <wkchen_at_bigfoot.com> wrote in message news:nDiN8.2314$v66.323682_at_twister.nyc.rr.com...
> This maybe a bit easy for someone. here's what i want to do. say i have a
> TEAM table
>
> create table Team
> (
> ID int
> TeamName varchar(50),
> Player varchar (20)
> )
> my current population of this table is this
>
> ID TeamName Player
> Team1 Mike
> Team1 David
> Team1 Henry
> Team2 Derik
> TEam2 Jerry
>
> the result i want to have a query looks like this:
>
> ID TeamName Player
> 1 Team1 Mike
> 2 Team1 David
> 3 Team1 Henry
> 1 Team2 Derik
> 2 TEam2 Jerry
>
>
> anyone have any ideas? the id doesn't have to be alphabetically order of
> the player's name. I just want the order of the ID the way it display now.
>
> thanks
Received on Tue Jun 11 2002 - 05:22:41 CDT