How to sort and pick values.

[#1]

Hi guys,

I got one data set like following:

first                           second        Third

01/12/2014                    1               12

01/12/2014                    3               23

01/13/2104                    2               14

I need to pick that value of the Third column whose second column's value is the highest one.

In this example it should be 23 because 3 is the highest one.

Regards,

Saurabh

[anbu1984 · Accepted solution]

LOAD first,FirstSortedValue(second,-second) As second,FirstSortedValue(Third,-second) As Third Group By first;

Load * Inline [

first,second,Third

01/12/2014,1,12

01/12/2014,3,23

01/13/2104,2,14 ];