데이터베이스 질문과 답변
by 마농
[2018.01.03 11:44:02]
SELECT 'A' nm, a v FROM t WHERE a > 0 UNION ALL SELECT 'B', b FROM t WHERE b > 0 UNION ALL SELECT 'C', c FROM t WHERE c > 0 ;
SELECT 'A' nm, a v FROM t WHERE a > 0 UNION ALL SELECT 'B', b FROM t WHERE b > 0 UNION ALL SELECT 'C', c FROM t WHERE c > 0 ;
) 버튼을 클릭하여 작성 하시면 됩니다.