Facebook
Twitter
LinkedIn
Instagram
Whatsapp
Call Now
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

GoodFirms Badge
GoodFirms Badge

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