Query for finding the tuple with other corresponding elements of value x
If we have the following table called data:
`(id, n1, n2, n3, n4)
111,  2,  4,  7, 0
444,  1,  1,  2, 1
555,  1,  1,  2, 0
777,  5,  3,  8, 0`

How do we get only (2,4,7) and (5,3,8)?

SELECT DISTINCT n1,n2,n3
FROM data
WHERE n4 = 0;

doesn't work as it returns the (1,1,2) tuple as well. I only need the tuples that have n4 = 0 all the time.
Query for finding the tuple with other corresponding elements of value x
===

If we have the following table called data:
`(id, n1, n2, n3, n4)
111,  2,  4,  7, 0
444,  1,  1,  2, 1
555,  1,  1,  2, 0
777,  5,  3,  8, 0`

How do we get only (2,4,7) and (5,3,8)?

SELECT DISTINCT n1,n2,n3
FROM data
WHERE n4 = 0;

doesn't work as it returns the (1,1,2) tuple as well. I only need the tuples that have n4 = 0 all the time.