一次简单的列转行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,’~’,hi...
原创
2020-01-17 13:56:02 ·
220 阅读 ·
0 评论