SELECT STREAM_ELEMENT_DATE, SUM(AMOUNT), CURRENCY_CODE, DATE_BILLED, STY_ID, KHR_ID FROM OKL_CS_PAYMENT_DETAIL_UV WHERE KHR_ID = KHR_ID GROUP BY CURRENCY_CODE,DATE_BILLED,STY_ID,STREAM_ELEMENT_DATE,KHR_ID
View Text - HTML Formatted
SELECT STREAM_ELEMENT_DATE , SUM(AMOUNT) , CURRENCY_CODE , DATE_BILLED , STY_ID , KHR_ID FROM OKL_CS_PAYMENT_DETAIL_UV WHERE KHR_ID = KHR_ID GROUP BY CURRENCY_CODE , DATE_BILLED , STY_ID , STREAM_ELEMENT_DATE , KHR_ID