CODEWITHSUNDEEP
sqlunique-values
OJ Slott
OJ Slott

Reputation: 79

SQL - Select non duplicates column values

I have the following SQL table containing a group ID, and the users that needs access to the groups. I have 3 types of users, but if it is the same user in all 3 types, then I only need to select 1 and not all 3.

This is my table:

This is my table:

And this is the result I would like from the select

Result

Any help is appreciated :)

Upvotes: 1

Views: 185

Answers (1)

Viktor Török
Viktor Török

Reputation: 1319

You can use 3 selects with union:

select group_id,
       csp
  from your_table
union
select group_id,
       ep
  from your_table
union
select group_id,
       em
  from your_table
order by 1, 2;

Union will eliminate the duplicates.

Upvotes: 2

Related Questions