求教个SQL写法（SQL SERVER 2008）

Question

实现后就是这样的

说一下我的原表：name(车名),tonage（载客量）
然后就是把载客量放到对应的区间上

Answer 1

 SELECT 
    name,
    CASE tonage 
        WHEN tonage < 10 THEN tonage
        ELSE NULL 
    END tonage_10,
    CASE tonage 
        WHEN tonage >= 10 AND  tonage< 30 THEN tonage
        ELSE NULL 
    END tonage_10_30,
    CASE tonage 
        WHEN tonage >= 30 AND  tonage< 90 THEN tonage
        ELSE NULL 
    END tonage_30_90,
    CASE tonage 
        WHEN tonage >= 90 AND  tonage< 100 THEN tonage
        ELSE NULL 
    END tonage_90_100,
    CASE tonage 
        WHEN tonage >= 100 THEN tonage
        ELSE NULL 
    END tonage_100
FROM TABLE_NAME