How to write a sql query to get the same data?

Question

PostgreSQL

Hello.
There is a table in the database like this:

I need to make a request by specifying id to get data, and if there is duplicate data in id_input, then get them.
For clarity, I'll show you a picture. Sending a request specifying id 1001, I expect to receive the following data


. I try to send such a request, but there is no result

SELECT id, id_input, id_out
FROM data
WHERE id= 1001
GROUP BY id
HAVING COUNT(DISTINCT id_input)>1

What needs to be added to the request?

Answer 1

It is possible through JOIN:

SELECT t2.* FROM t t1 JOIN t t2 ON t1.input_id = t2.input_id
WHERE t1.id=1

Example