Skip to content
Advertisement

Possible to select only 1 row for usernames, even though multiple rows which include usernames are unique

I am trying to select all usernames that have a at least one windows operating system. Some users have many windows operating systems, but I really only need to know if they have at least one.

I know DISTINCT can filter out duplicates, but the issue is these rows are unique, if they have more than one OS. For example:

JohnDoe windows 10;
JohnDoe windows 97;
JohnDoe windows 7;
JennyDoe windows 10;

In this case, JohnDoe will be selected 3 times because he has 3 unique operating systems.

Is there a way to essentially say, if an instance of this username appears, only select one row?

Advertisement

Answer

The easiest way is to use DISTINCT:

select distinct username
  from your_table
  where operating_system like '%%windows%%'

Based on the data shown in the question, this will return

JohnDoe
JennyDoe

db<>fiddle here

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement