MySQL行成列数和总和 [英] MySQL row into number of columns and sum

问题描述

有人可以帮助我处理SQL吗?

Could somebody help with my SQL?

我有一张记录如下的表:

I have a table with records such as:

ID | Car_num | Service | Price
---+---------+---------+------
1  | 001     | shower  | 10
2  | 002     | TV      |  5
3  | 001     | TV      |  5

如何编写SQL查询以获取以下输出?

How to write an SQL query to get the following output?

ID |Car_num | shower | TV
---+--------+--------+---
1  | 001    | 10     | 5
2  | 002    |  0     | 5

推荐答案

尝试一下:

SELECT ID, Car_num
   , SUM(IF(Service = 'shower', Price, 0)) AS Shower
   , SUM(IF(Service = 'TV', Price, 0)) AS TV
FROM your_table
GROUP BY Car_num;

这篇关于MySQL行成列数和总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！