데이터베이스 질문과 답변
안녕하세요 쿼리 질문드립니다.
| 알파벳 | 숫자1 | 숫자2 |
| A | 1 | |
| A | 1 | |
| B | 1 | |
| B | 1 |
| 알파벳 | 숫자1 | 숫자2 |
| A | 1 | 1 |
| B | 1 | 1 |
위에 첫번째 테이블을 아래 결과로 뽑을 수 있을까요?
Group by로 하니깐 잘안되서...
by JYK94
[2020.06.22 11:39:40]
WITH T AS (SELECT 'A' AS A, 1 AS B, NULL AS C FROM DUAL UNION ALL SELECT 'A' AS A, NULL AS B, 1 AS C FROM DUAL UNION ALL SELECT 'B' AS A, 1 AS B, NULL AS C FROM DUAL UNION ALL SELECT 'B' AS A, NULL AS B, 1 AS C FROM DUAL) SELECT A, MAX ( B ) AS B, MAX ( C ) AS C FROM T GROUP BY A
by 구루업투
[2020.06.22 15:48:29]
감사합니다!
) 버튼을 클릭하여 작성 하시면 됩니다.