postgresql行专列

postgresql行专列

问:怎么分页&&按条件&&按顺序&&姓名不重复查出数据?

答:其实就是行转列,那么,postgresql怎么进行转列呢,百度了下,大概有三种写法

 

写法1  group by + sum + case when

select name, sum(case when zbfm='年龄' then value else 0 end) as 年龄, sum(case when zbfm='身高' then value else 0 end) as 身高, sum(case when zbfm='体重' then value else 0 end) as 体重 from test group by name having name like '%1' and length(name)=4 order by 年龄 desc

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/wpsjfp.html