query
Hi ,
what is wrong in the 1st query.
SQL> select nvl(CIRCLEID,'NULL') as CIRCLEID,TOADDRESS as shortcode, nvl(sum(decode(RESULT,'0',WEIGHT)),0) as delivered,
2 nvl(sum(decode(RESULT,'2',WEIGHT,'1',WEIGHT)),0) as undelivered, nvl(sum(decode(RESULT,'2',WEIGHT,'1',WEIGHT,'0',WEIGHT)),0) as submitted
3 from TBL_NTFYSMSRCT WHERE TO_DATE(SUBSTR(TIMESTAMP,1,10),'YYYY-MM-DD') >= '2010-03-01' AND TO_DATE(SUBSTR(TIMESTAMP,1,10),'YYYY-MM-DD') <= '2010-03-03'
AND TRANSACTIONTYPE IN ('105','106') group by circleid,TOADDRESS
4 5 /
from TBL_NTFYSMSRCT WHERE TO_DATE(SUBSTR(TIMESTAMP,1,10),'YYYY-MM-DD') >= '2010-03-01' AND TO_DATE(SUBSTR(TIMESTAMP,1,10),'YYYY-MM-DD') <= '2010-03-03'
SQL> select nvl(CIRCLEID,'NULL') as CIRCLEID,TOADDRESS as shortcode, nvl(sum(decode(RESULT,'0',WEIGHT)),0) as delivered,
2 nvl(sum(decode(RESULT,'2',WEIGHT,'1',WEIGHT)),0) as undelivered, nvl(sum(decode(RESULT,'2',WEIGHT,'1',WEIGHT,'0',WEIGHT)),0) as submitted
3 from TBL_NTFYSMSRCT WHERE TO_DATE(SUBSTR(TIMESTAMP,1,10),'YYYY-MM-DD') >= '2010-03-01' AND TO_DATE(SUBSTR(TIMESTAMP,1,10),'YYYY-MM-DD') <= '2010-03-03'
AND TRANSACTIONTYPE IN ('105','106') group by circleid,TOADDRESS
4 5 /
from TBL_NTFYSMSRCT WHERE TO_DATE(SUBSTR(TIMESTAMP,1,10),'YYYY-MM-DD') >= '2010-03-01' AND TO_DATE(SUBSTR(TIMESTAMP,1,10),'YYYY-MM-DD') <= '2010-03-03'
0