Select multiple rows with condition on each columns

Question

I am sure this could be very silly question, but I was not able to find answer from the internet.

I am trying to select rows with this conditon.

Select all rows if Side has both 'Right' and 'Left'.

In this case, it will select both row of Id 3 and 4 (yellow highlighted ones).

I know bottom query is not going to work.

select * from "Table" where ("Side" = 'Right') or ("Side" = 'Left')

How do I go about doing this?

Mike · Accepted Answer · 2019-01-30 01:27:45Z

2

You need a join. If your table name is processes

select 
 p.*
from processes p

inner join processes p2
on p.pid = p2.pid 
and p.id <> p2.id
and p.side <> p2.side

answered Jan 30, 2019 at 1:27

Mike

1641 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kaushik Nayak · Accepted Answer · 2019-01-30 03:23:31Z

0

You may filter it using a WHERE & HAVING clause in a GROUP BY

SELECT *
  FROM t
    WHERE pid IN (
       SELECT pid
           FROM t
          WHERE side IN (
           'Right',
           'Left' )
     GROUP BY pid
     HAVING COUNT(DISTINCT side) = 2 )

Demo

answered Jan 30, 2019 at 3:23

Kaushik Nayak

32k6 gold badges36 silver badges54 bronze badges

Collectives™ on Stack Overflow

Select multiple rows with condition on each columns

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related