有图有真相!过个Happy的节日吧!来看看了!!关于查询

Question

这样怎么做呢?麻烦大家帮写一下!祝大家双节Happy!!

Answer 1

select oilstandard, sum(case PIN when '93#' then RetailLiterprice else 0 end) as '93#', sum(case PIN when '97#' then RetailLiterprice else 0 end) as '97#', sum(case PIN when '0#' then RetailLiterprice else 0 end) as '0#' from cnblogs group by OilStandard不知道是不是楼主想要的结果

Answer 2

select RetailiterPrice1=（select RetailiterPrice from ”table“ where PIN=”93#“）,RetailiterPrice2=（select RetailiterPrice from ”table“ where PIN=”97#“）,RetailiterPrice3=（select RetailiterPrice from ”table“ where PIN=”0#“） from  "table" where oilstandard="国III"大概是这个意思吧，你可以试下。