queyr (maximum)

hi,

I want the transactions and levels which level is maximum and version is maximum, knowing the version has priority (version > level)

 Transaction          Level         Version                code

teti                                0          1            A

titi                                1          2            A

tuta                              0         1               B

tata                              1         1                B

toto                              0          1               C

tuto                              1         1                C

gives:

titi 1 2 A

tata 1 1 B

tuto 1 1 C

The query:

   select a.transaction,max(version),max(level), a.code,     from ma_table a
    group by a.transaction, a.level

gives wrong results of course.

Thanks for your help Received on Tue Jul 22 2003 - 17:57:55 CDT