Skip to Content
0
Former Member
Apr 28, 2009 at 07:27 PM

Sum distinct possible/

351 Views

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)))