一次简单的列转行sql案例

select type_id ‘类型id’,create_time, update_name,MAX(case star_level when 1 then CONCAT(lowest_score,’~’,highest_score) else ‘’ end ) ‘一星分值范围’, MAX(case star_level when 2 then CONCAT(lowest_score,’~’,highest_score) else ‘’ end ) ‘二星分值范围’, MAX(case star_level when 3 then CONCAT(lowest_score,’~’,highest_score) else ‘’ end ) ‘三星分值范围’, MAX(case star_level when 4 then CONCAT(lowest_score,’~’,highest_score) else ‘’ end ) ‘四星分值范围’, MAX(case star_level when 5 then CONCAT(lowest_score,’~’,highest_score) else ‘’ end ) ‘五星分值范围’ from db_grade_standard group by type_id;