Table ordering help

[Ruslan Zasukhin]

On 2/7/09 12:19 AM, "Antuan Johnson" <amjohnson09 at gmail.com> wrote:

Hi Antuan,

> I'm a developer of chart game and I need help with formulating a way to show
> charts. I need to sort the data in the table by the column(Sales) of the table
> descending and then by using that I have to somehow generate new ids that show
> their new position, and then put them in their own column (Chart Position)
> 
> Any ideas about how this can achieved with Valentina or an alternative that
> would work equally as well?
> 
> Current Table 
> Sales, Chart Position
> 500,0
> 300,0
> 100,0
> 900,0
> 
> What I need accomplished
> Sales, Chart Position
> 900,1
> 500,2
> 300,3
> 100,4

So what question is?

How to so SELECT?  Or UPDATE?

I have not catch MAIN question ?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]