I need sql statment to do( select one comlmn if another is have defrent value)

Question

sql

Answer 1

Unfortunately there is no sql play ground so I cannot test my statement.

What you are looking for is the opposite of distinct
which is
group by having count > 1

Select name, status from table1 group by name having count > 1

Answer 2

Please explain the question a bit more. I think it is a good question but I do not understand the question with the information you gave.

Can you show use a example ?

Answer 3

Thank you for your explanation.

I do understand your question better now.
Unfortunately I still do not understand everything
What is the result you expect based on the columns you have given ?

Answer 4

Thank you now I understand.
The question is clear to me, let me think about the statement.

Answer 5

thanks for you
i have two column:
name status
______ _______
mh active
mh busy
go active
has active
has offline
has busy
yas busy

I wana select name and status if is name have a many and defrent status
I hope my ex is is good
thanks

Answer 6

I need below result:
name status
______ ______
mh active
mh busy
has active
has offline
has busy

Answer 7

many thanks for you

Answer 8

thanks
I will try and back