쿼리 질문 드립니다.2
- 더움
- 등록일 2015-09-22 09:07
- 조회수 395
|
||
0
추천하기
다른의견
0
|
파워링크 
등록안내
|
|
|
 |
|
| △ 이전글▽ 다음글 | -목록보기 |
|
|
||
등록안내
|
|
|
|
|
| △ 이전글▽ 다음글 | -목록보기 |
|
아래는 오라클로 표현한 예시 입니다.
WITH LIST AS (
SELECT \'컴공\' AS CLASS, \'3\' AS GRADER , \'홍길동\' AS NAME, \'데이터베이스\' AS SUBJECT, \'A\' AS GRADE FROM DUAL UNION ALL
SELECT \'컴공\' AS CLASS, \'3\' AS GRADER , \'홍길동\' AS NAME, \'네트워크\' AS SUBJECT, \'B\' AS GRADE FROM DUAL UNION ALL
SELECT \'컴공\' AS CLASS, \'1\' AS GRADER , \'임꺽정\' AS NAME, \'데이터베이스\' AS SUBJECT, \'A\' AS GRADE FROM DUAL UNION ALL
SELECT \'컴공\' AS CLASS, \'2\' AS GRADER , \'김수현\' AS NAME, \'데이터베이스\' AS SUBJECT, \'A\' AS GRADE FROM DUAL UNION ALL
SELECT \'컴공\' AS CLASS, \'4\' AS GRADER , \'장동건\' AS NAME, \'경영학개론\' AS SUBJECT, \'A+\' AS GRADE FROM DUAL UNION ALL
SELECT \'컴공\' AS CLASS, \'4\' AS GRADER , \'장동건\' AS NAME, \'미사경제론\' AS SUBJECT, \'B\' AS GRADE FROM DUAL
)
SELECT A.CLASS, A.GRADER, A.NAME, A.SUBJECT, A.GRADE, DECODE(B.CNT, 1, \'\', \'V\') AS ETC
FROM LIST A
,(SELECT CLASS, GRADER, NAME, COUNT(*) AS CNT FROM LIST GROUP BY CLASS, GRADER, NAME) B
WHERE A.CLASS = B.CLASS
AND A.GRADER = B.GRADER
AND B.NAME = B.NAME