select je1=(case when year <5 then je else null end), 
     je2=(case when year between 5 and 10 then je else null end), 
     je3=(case when year between 10 and 20 then je else null end), 
     je4=(case when year between 20 and 30 then je else null end) 
     from table 
    Ëµ Ã÷ :±¾ SQL·µ »Ø ËÄ ¸ö ÁÐ ¡£ 
<END>
