informox는 처음이라 당황스럽네요...
아래와 같은 쿼리를 인포믹스에서 돌렸더니 에러가 나던데 인포믹스에선 어떻게 수정해야 할까요..
SELECT MAX (CNT2000) AS CNT2000,
MAX (CNT2001) AS CNT2001,
MAX (CNT2002) AS CNT2002,
MAX (CNT2003) AS CNT2003,
MAX (CNT2004) AS CNT2004,
MAX (CNT2005) AS CNT2005,
MAX (CNT2006) AS CNT2006,
MAX (CNT2007) AS CNT2007,
MAX (CNT2008) AS CNT2008,
MAX (CNT2009) AS CNT2009
FROM (
SELECT COUNT(CASE WHEN SRCH_PUBYEAR='2000' THEN 1 END) AS CNT2000,
COUNT(CASE WHEN SRCH_PUBYEAR='2001' THEN 1 END) AS CNT2001,
COUNT(CASE WHEN SRCH_PUBYEAR='2002' THEN 1 END) AS CNT2002,
COUNT(CASE WHEN SRCH_PUBYEAR='2003' THEN 1 END) AS CNT2003,
COUNT(CASE WHEN SRCH_PUBYEAR='2004' THEN 1 END) AS CNT2004,
COUNT(CASE WHEN SRCH_PUBYEAR='2005' THEN 1 END) AS CNT2005,
COUNT(CASE WHEN SRCH_PUBYEAR='2006' THEN 1 END) AS CNT2006,
COUNT(CASE WHEN SRCH_PUBYEAR='2007' THEN 1 END) AS CNT2007,
COUNT(CASE WHEN SRCH_PUBYEAR='2008' THEN 1 END) AS CNT2008,
COUNT(CASE WHEN SRCH_PUBYEAR='2009' THEN 1 END) AS CNT2009
FROM DT_SVC_ITEM SVC, DT_COLLECTION COLL
WHERE SVC.COLL_ID = COLL.COLL_ID AND COLL.PUBLIC_TYPE ='1'
AND SRCH_PUBYEAR IN ('2000', '2001', '2002', '2003', '2004', '2005', '2006', '2007', '2008', '2009')
AND EXISTS (SELECT 1 FROM DT_SVC_ITEM_SOMS SOMS WHERE SVC.ITEM_ID=SOMS.ITEM_ID AND SOMS.ELEMENT_ID='034' AND SOMS.CONTENT='Dissertation')
GROUP BY SRCH_PUBYEAR)
|