sql. how to select rows based on values of other columns in sql ?

• Yogesh Kumar
• 04-May-2022
• 0

 select * from mytable a
    where exists (select 'Roll' from mytable b where a.column_1 = b.column_1 and b.column_2 = 'yes')
    and exists (select 'Tide' from mytable c where a.column_1 = c.column_1 and c.column_2 = 'no')

* Be the first to Make Comment