안녕하세요....
데이타가 아래와 같이 입력이 되는대요...
20120416 AS AAA, AUD AS BBB, 33.00 AS CCC
UNION ALL
20120416 AS AAA, USD AS BBB, 12.00 AS CCC
UNION ALL
20120417 AS AAA, JPY AS BBB, 13.00 AS CCC
UNION ALL
20120417 AS AAA, USD AS BBB, 15.00 AS CCC
UNION ALL
20120423 AS AAA, USD AS BBB, 12.00 AS CCC
UNION ALL
20120423 AS AAA, JPY AS BBB, 10.00 AS CCC
UNION ALL
20120423 AS AAA, EUR AS BBB, 23.00 AS CCC
UNION ALL
20120423 AS AAA, CNY AS BBB, 20.00 AS CCC
날짜기간 별로 통화코드별 금액이 조회가 되어야하는대요.
예를들어
USD같은 경우는 16,17, 23일 입력이 되었는대
특정기간으로 조회가 될때는
------------------------------------------------------
AAA BBB CCC DDD
20120416 USD 12
20120417 USD 15 3
20120423 USD 12 -3
이렇게 통화코드별 등록된 날짜 전후로 이전과 현재의 CCC값의 차이를 보여주어야하는대요.
JSP스크립트로 DDD값을 가져와 뿌려주지 않고 SQL한번으로 해주려니...
잘 안되서요....
좀 도움주시면 감사하겠습니다..^^^;;;
|