Code: Select all
select PS_DATE,PS_HOUR,SUBSCRIBER_ID,SUBSCRIBER_TYPE,MESSAGE_TYPE,SUBTYPE_ID,
CIRCLE_ID,SP_ID,SUBSCRIBER_ID,BALANCE_ID,
sum(CHANGE_AMOUNT)CHANGE_AMOUNT,count (*)no_of_SMS from
(select VARCHAR_FORMAT(DATE_time ,'DD-MM-YYYY')PS_DATE
,VARCHAR_FORMAT(DATE_time,'HH24')PS_HOUR
,SUBSCRIBER_TYPE,MESSAGE_TYPE,SUBTYPE_ID, CIRCLE_ID,SP_ID,SUBSCRIBER_ID,BALANCE_ID,
CHANGE_AMOUNT
from INUSG.PS_TRANSACTION_DETAILS_JAN2013
where SUBSCRIBER_ID = '0782670472'
)
group by
PS_DATE,PS_HOUR,MESSAGE_TYPE,SUBSCRIBER_ID,SUBSCRIBER_TYPE,SUBTYPE_ID,CIRCLE_ID,
SP_ID,SUBSCRIBER_ID,BALANCE_ID
Please help me?