Quick Inquiry

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

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

 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')

7 0

Write a Comments

* Be the first to Make Comment

Fix Your Meeting With Our SEO Consultants in India To Grow Your Business Online