需要获得完全匹配的行[关闭]

Question

Here i have a query

 make           |  model | disc
 maruti suzuki     ritz     Y  
 maruti suzuki     swift    N
 maruti suzuki     swift    Y
 Hyundai           i10      Y
 Hyundai           i20      Y
 Hyundai           eon      N
 tata              indica   Y
 tata              nano     Y
 tata              safari   Y

i have tried with the below query

  select * from table_name where disc='Y' and disc!='N'

but i got the result like this

    make           |  model | disc
    maruti suzuki     ritz     Y  
    maruti suzuki     swift    Y
    Hyundai           i10      Y
    Hyundai           i20      Y
    Hyundai           i10      Y
    Hyundai           i20      Y
    tata              indica   Y
    tata              nano     Y
    tata              safari   Y

Here now i need all makes list that must having all models disc type Y

that means my output should be

 make              model   disc  
 tata              indica   Y
 tata              nano     Y
 tata              safari   Y     

Answer 1

You just use a simple WHERE clause for this, nothing fancy:

SELECT * from cars WHERE make NOT IN (SELECT make FROM cars WHERE disc = 'N')

Here is a working DEMO