mysql行转列多行一列转一行多列

最新推荐文章于 2024-07-08 19:28:21 发布

码农小麦

最新推荐文章于 2024-07-08 19:28:21 发布

阅读量435

点赞数

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/weixin_43275277/article/details/130811143

版权

round1

select 95 as score
union all
select 85
union all 
select 100

在这里插入图片描述
round2

select 'star' as biz,95 as score
union all
select 'moon',85
union all 
select 'sun',100

在这里插入图片描述
round3

select case when biz='star' then score end as star,
case when biz='moon' then score end as moon,
case when biz='sun' then score end as sun
from(
select 'star' as biz,95 as score
union all
select 'moon',85
union all 
select 'sun',100) a

在这里插入图片描述
round4

select max(case when biz='star' then score end) as star,
max(case when biz='moon' then score end) as moon,
max(case when biz='sun' then score end) as sun
from(
select 'star' as biz,95 as score
union all
select 'moon',85
union all 
select 'sun',100) a