How can I aggregate and arrive to these results?
x
SELECT *
FROM TABLE
GROUP BY Column1
Advertisement
Answer
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;