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

Max wrote:

Post what the results should look like. We can't read your mind.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)