SQL - Select non duplicates column values

Question

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:

And this is the result I would like from the select

Any help is appreciated :)

Also: you need distinct values always, or only when the count is three? (eg. if the count is 2, you display that 1 or 2 times?) — Emanuele, Jul 06 '21 at 10:07
I don't have any code yet because I do not know how to solve it — OJ Slott, Jul 06 '21 at 10:14

Kapitany · Accepted Answer · 2021-07-06T10:14:06.980

2

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.

edited Jul 06 '21 at 10:14

answered Jul 06 '21 at 10:08

Kapitany

1,319
1
6
10

SQL - Select non duplicates column values

1 Answers1