select deptno
,count(case when job = 'CLERK' then 1 end) as clerk
,count(case when job = 'SALESMAN' then 1 end) as salesman
,count(case when job = 'MANAGER' then 1 end) as manager
from emp
group by deptno
order by deptno
,count(case when job = 'CLERK' then 1 end) as clerk
,count(case when job = 'SALESMAN' then 1 end) as salesman
,count(case when job = 'MANAGER' then 1 end) as manager
from emp
group by deptno
order by deptno
'기타' 카테고리의 다른 글
| 버즈 모놀로그 (0) | 2007.04.23 |
|---|---|
| 울지마 (0) | 2007.04.18 |
| 농구가 아니라 격투기군요．．． (0) | 2007.04.13 |
| 민방위 훈련 이렇게 하는구나．． (0) | 2007.04.13 |
| [스크랩] 예레미야 23장 (0) | 2007.04.11 |