Welcome to The Community. The community is designed to share information on SAP HANA in an interactive way.

Visit SAPHANATutorial.Com
Comparing dates in diffrent rows
  • Hello guys,

    I need your help in HANA SAP. I'm trying to compare dates in different rows, like:


    ID   |     NAME     |   DATE          |   STEP
    ---------------+----------------+-----------------+-----------
    132            |      TEST     |  01.01.2001  | CREATED
    132            |      TEST     |  05.01.2001  | SOLVED
    154   | Other      |  06.01.2001  | CREATED
    175            |      Card      |  08.01.2001  | CREATED
    175            |      Card      |  09.01.2001  | SOLVED

    So my Problem is, I want to pick the row with the higher date in HANA SAP, but I dont know how I could do that. 
    First I have to compare the ID's and pick the ID's which are double or more and than pick the ID with the higher date.

    I would be grateful for your help.

    Best regards

Howdy, Stranger!

It looks like you're new here. Sign In using your Gmail ID, Click on 'Google' button to sign in

Free Online Training Programs under SAPHANATutorial.com:
Click here to start SAP HANA Basics online course.
© 2016 : saphanatutorial.com, All rights reserved.
Visit SAPHANATutorial.Com