T-SQL分组依据使用逻辑功能汇总字段

由不懂珍惜发布于 2020-05-18 11:41:02

如何汇总并得出这些结果？

SELECT *
FROM TABLE
GROUB BY Column1

2020-05-18 11:41:02

Assuming the columns actually contain the literal string values 'TRUE' and 'FALSE', we could use:

SELECT
    Column1,
    MAX(Column2) AS Column2,
    MAX(Column3) AS Column3
FROM yourTable
GROUP BY
    Column1;

这家伙很懒，什么都没留下