Retrun True for rows with same values in multiple columns in SQL

Question

id | code |
12 | US   | 
12 | US   |
13 | US   |
13 | AZ   |
14 | US   |
14 | AZ   |

I want to return a column that says True if the code for every pair is same and false if not. Want to check for pairs of ids. All id values in the column are in pairs

Expected Result of this question

id | match |
12 | TRUE
13 | FALSE
14 | FALSE

Tried solving it similar to : Finding rows with same values in multiple columns but the answer was too long

jarlh · Accepted Answer · 2020-03-25 22:05:53Z

3

Do a GROUP BY. If the max(code) = min(code), they are equal.

select id, max(code) = min(code)
from tablename
group by id

You can also use count() instead, for example if the rows don't come in pairs.

select id, count(distinct code) = 1
from tablename
group by id

edited Mar 25, 2020 at 22:05

answered Mar 25, 2020 at 21:35

jarlh

44.9k8 gold badges52 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Retrun True for rows with same values in multiple columns in SQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related