 <p>You could do something like this:</p> <pre><code>select ID, max(case when CVG = 'A' then 'TRUE' else 'FALSE' end), max(case when CVG = 'B' then 'TRUE' else 'FALSE' end), max(case when CVG = 'C' then 'TRUE' else 'FALSE' end), from table group by ID </code></pre> <p>The case + max will select the true if even one row is found for that ID, otherwise false.</p>