Show the latest date only for duplicate data

[Anonymous]

data given

number   id      date

123       1      1/1/2015

123       2      2/1/2015

124       8      12/12/2014

125       7      (blank)

125       7      5/1/2015

125       7      8/1/2015

126       4      7/7/2015

126       4      (blank)

expected result:

number   id      date

123       1      1/1/2015

123       2      2/1/2015

124       8      12/12/2014

125       7      8/1/2015

126       4      7/7/2015

Please help. Thanks.

[jagan]

Hi,

Try like this

LOAD

number,

id,

Date(Max(date)) AS date

FROM DataSource

GROUP BY number, id;

Hope this helps you.

Regards,

Jagan.