|
SELECT TIME_MIN, HALF_TYPE, COUNT(TIME_MIN)
FROM PLAYER_CHANGE
WHERE YEAR = '2009'
AND SEQ = '1'
AND ID = '1'
GROUP BY TIME_MIN, HALF_TYPE
---------------------------------------------
TIME_MIN | HALF_TYPE | COUNT(TIME_MIN)
---------------------------------------------
0 2 3
---------------------------------------------
19 2 1
---------------------------------------------
23 2 1
---------------------------------------------
45 2 1
---------------------------------------------
SELECT TIME_MIN, HALF_TYPE, COUNT(TIME_MIN)
FROM WARN_STATE
WHERE YEAR = '2009'
AND SEQ = '1'
AND ID = '1'
GROUP BY TIME_MIN, HALF_TYPE
---------------------------------------------
TIME_MIN | HALF_TYPE | COUNT(TIME_MIN)
---------------------------------------------
15 1 1
---------------------------------------------
20 1 1
---------------------------------------------
25 1 1
---------------------------------------------
38 1 1
---------------------------------------------
40 1 1
---------------------------------------------
9 2 1
---------------------------------------------
SELECT TIME_MIN, HALF_TYPE, COUNT(TIME_MIN)
FROM GOAL_STATE
WHERE YEAR = '2009'
AND SEQ = '1'
AND ID = '1'
GROUP BY TIME_MIN, HALF_TYPE
---------------------------------------------
TIME_MIN | HALF_TYPE | COUNT(TIME_MIN)
---------------------------------------------
6 1 1
---------------------------------------------
16 1 1
---------------------------------------------
37 1 1
---------------------------------------------
40 2 1
---------------------------------------------
45 2 1
---------------------------------------------
위의 쿼리를 한개의 쿼리문으로 해서 돌려면.. 어떻게 해야 할까요?
위의 테이블에서 중복되는 값도 있습니다.
고수님들의 조언을 기다리겠습니다. |
