Get Distinct values using CE function in HANA procedure

[ganesh_karnati2]

Hi All,

Could you please let me know how to get distinct values using CE function from column table.

IT_WORK = SELECT DISTINCT AUFNR FROM :IT_WO_DETAILS;

Thanks

Kumar

[former_member182302]

You can use CE_AGGREGATION and form a GROUP BY clause to get distinct values

Regards,

Krishna Tangudu