Below HANA Query is not sorting the group value based on date and time in descending order.

[Pankaj-Kumar]

Below HANA Query is not sorting the Partition's members based on date and time in descending order.

"select mandt, kappl,

objky,

kschl,

spras,

parnr,

parvw,

erdat,

eruhr,

nacha,

aende,

vstat,

row_number( ) OVER ( PARTITION BY mandt,kappl,objky,kschl,spras,parnr,parvw ORDER BY erdat, eruhr desc ) as row_num

FROM nast

WHERE mandt = SESSION_CONTEXT( 'CLIENT' );"

[Pankaj-Kumar · Accepted solution]

Got the Answer -

There is an issue with syntax:

Correct syntax should be: ORDER BY erdat desc , eruhr desc.

So complete answer would be -

select mandt, kappl,

objky,

kschl,

spras,

parnr,

parvw,

erdat,

eruhr,

nacha,

aende,

vstat,

row_number( ) OVER ( PARTITION BY mandt,kappl,objky,kschl,spras,parnr,parvw ORDER BY erdat desc, eruhr desc ) as row_num

FROM nast

WHERE mandt = SESSION_CONTEXT( 'CLIENT' );

[CharlesFeng · Accepted solution]

Thanks pankajkumaram for sharing.