Skip to Content
Former Member
Dec 18, 2013 at 08:41 PM

how to pass last record that have few input records


Hi All,

i have table with 2 rows that contain 3 columns.

c1 c2 c3

x 01/01/2010 10

x 01/01/2012 5

the 2 records have the same value in column c1

i need that the output will take only one reocrd for each value from c1 ( in my example x )

the record with the max value and the value of c3 of the same max date value from column c2

so in my example in need that the output file will take only the second recrod.

c1 c2 c3

x 01/01/2012 5