Maximum of a decode statement

From: Kevin Bass <akil1_at_mindspring.com>
Date: 1998/09/01
Message-ID: <6si1o5$ceb$1_at_camel29.mindspring.com>#1/1


Using a decode statement, how can I determine the maxium of the associated type of a code?

CODE TYPE RANK

K-LIFE   LE01 1
K-LIFE   LE02 2
K-LIFE   LE03 3


CODE TYPE RANK

L-LIFE   LS10   1
L-LIFE   LS25   2
L-LIFE   LS 30  3


Kevin Received on Tue Sep 01 1998 - 00:00:00 CEST

Original text of this message