sql - 如何让虚拟变量显示在一行中

Question

我的表是这样的:

0    Number Certification
1    400009           CSR
2    400009            MD
3    400009           MHP
4    400032           CSP
5    400032           MH

在我使用 get dummy 之后，表格是这样的:

 Number  Certification_ACD  ...  Certification_TSC  Certification_TSE
1    400009                  0  ...                  0                  0
2    400009                  0  ...                  0                  0
3    400009                  0  ...                  0                  0

我希望数字列只显示一次。任何人都可以帮忙吗？
谢谢!

Answer 1

以下查询应满足您的需求:

SELECT
    Number,
    SUM(Certification='ACD') AS Certification_ACD,
    SUM(Certification='TSC') AS Certification_TSC,
    SUM(Certification='TSE') AS Certification_TSE
FROM
    YourTable
GROUP BY
    Number
ORDER BY
    Number;