Re: Ranking?

Hi Manfred,

Sometimes the solution is right in front of you, but the cloud is to thick.
Thanks a lot, it worked like a charm. The reason I want this, is to have a
new type of index, so speed is not a issue and data file not big (just about
15000 records). I know, it's sounds silly.

Greetings Sjors


> >now I want to have this:
> >
> >id    name    data    rank
> >1    sully        567    2
> >2    sully        789    1
> >3    sully        456    3
> >4    denan       890    1
> >5    denan        678    2
>
> SELECT id, name, data, (SELECT count(*) + 1
>                           FROM tbl AS tmp
>                          WHERE tmp.name = tbl.name
>                            AND tmp.data > tbl.data) AS rank
>   FROM tbl;
>
> should get you going but might perform horribly without an index on
> name ...
>
> Servus
>  Manfred
>