Is sum(distinct) possible within the following statement.
(sum(ibt1.quantity) over (partition by rdr1.itemcode))
I tried it but I get an error saying - Wrong syntax near Over.
I tried
(sum(distinct(ibt1.quantity)over(partition by rdr1.itemcode)))