如何汇总并得出这些结果?
SELECT * FROM TABLE GROUB BY Column1
Assuming the columns actually contain the literal string values 'TRUE' and 'FALSE', we could use:
'TRUE'
'FALSE'
SELECT Column1, MAX(Column2) AS Column2, MAX(Column3) AS Column3 FROM yourTable GROUP BY Column1;
Assuming the columns actually contain the literal string values
'TRUE'
and'FALSE'
, we could use: