Select count distinct from SAP Hana table

geogou1973 — Fri, 02 Apr 2021 08:57:44 GMT

Hello,

I have the following sql

select
count(distinct mblnr)
from mkpf
inner join mseg on mkpf~mblnr=mseg~mblnr and mkpf~mjahr=mseg~mjahr
inner join ekko on mseg~ebeln=ekko~ebeln
where mkpf~vgart='WE'
and mseg~ebeln in
(select ebeln
from rseg
inner join rbkp on rseg~belnr=rbkp~belnr and rseg~gjahr=rbkp~gjahr
where rbkp~tcode<>'MR1M');

and does not run. It is running only if you give count(*)

Has anyone how can i write the sql in order to have the distinct results of the field mblnr

thank you in advance

topic Select count distinct from SAP Hana table in Connectivity & Data Prep

Select count distinct from SAP Hana table