I have a table with two columns
There are many rows with the same name, but with different values.
I want to create a function that returns a table with 2 columns. The first column is the
name and the second is a character, either
no, which refers to whether a name has a specific value or not.
If a name has the specific value at least at one of its values to return yes and if it does not have the specific value to return no.
With the answers so far, I return the same name many times with the corresponding values like
('BOB'-'NO','BOB'-'NO','BOB'-'NO','BOB'-'NO','BOB'-'YES','JAME'-'NO','JAME'-'NO','JAME'-'NO','JAME'-'NO','JAME'-'NO') for example.
I want to return a table like that:
because bob has a specific value that I want at least one time at his values and JAME has not the specific value in a row.