Skip to Content
0
Aug 04, 2023 at 11:15 AM

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

152 Views Last edit Aug 04, 2023 at 11:23 AM 4 rev

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' );"