즐거운 개발

select case when bookcategoryid='ENG01' then '소설'
when bookcategoryid='ENG03' then '시/에세이'
when bookcategoryid='ENG05' then '인문'
when bookcategoryid='ENG21' then '종교'
when bookcategoryid='ENG19' then '역사/문화'
when bookcategoryid='ENG23' then '예술/대중문화'
when bookcategoryid='ENG13' then '경제/경영'
when bookcategoryid='ENG15' then '자기계발'
when bookcategoryid='ENG17' then '정치/사회'
when bookcategoryid='ENG41' then '유아'
when bookcategoryid='ENG42' then '아동'
when bookcategoryid='ENG39' then '초등학습'
when bookcategoryid='ENG25' then '중/고학습'
when bookcategoryid='ENG38' then '청소년'
when bookcategoryid='ENG31' then '취업/수험서'
when bookcategoryid='ENG27' then '외국어'
when bookcategoryid='ENG09' then '건강'
when bookcategoryid='ENG29' then '과학'
when bookcategoryid='ENG26' then '기술/공학'
when bookcategoryid='ENG33' then '컴퓨터/IT'
when bookcategoryid='ENG07' then '가정/생활'
when bookcategoryid='ENG08' then '요리'
when bookcategoryid='ENG11' then '취미/스포츠'
when bookcategoryid='ENG32' then '여행/기행'
when bookcategoryid='ENG47' then '만화'
else '기타' end as bookcategoryname
 , count(*) from bookbank group by bookcategoryid order by bookcategoryid asc;

select name, id, regdt  from testTable where regdt  between to_date('2010030906','YYYYMMDDHH24') and to_date('2010033123','YYYYMMDDHH24') order by regdt  asc;