1 votes 1 votes Why Q1 not correct? Because it is fetching any red part and not every red part,right?? Why Q2 is not correct query? It takes 2 tables and comparing. Is it not fetching single red value? Databases sql databases query + – srestha asked Jan 25, 2018 srestha 464 views answer comment Share Follow See all 5 Comments See all 5 5 Comments reply shriram s 1 commented Jan 25, 2018 reply Follow Share I think Q2 will be correct had it been NOT EXIST because if a supplier supplies all red parts then the inner query will result in NULL set and NOT EXIST would have returned true. 1 votes 1 votes joshi_nitish commented Jan 25, 2018 reply Follow Share both are incorrect. Q1: Sid's will be selected if there is no red color part or there is only one red color part and supplier sells that red color part Q2 Sid's who does not sell at least one red color part. hence both Q1 and Q2 are incorrect. 1 votes 1 votes srestha commented Jan 27, 2018 i edited by srestha Jan 27, 2018 reply Follow Share @joshi_nitish chk this example If we consider these two tables According to question, we should return S3 but Q1 returning S1, S2, S3 and Q2 returning nothing Right?? 0 votes 0 votes joshi_nitish commented Jan 27, 2018 reply Follow Share which one ? 0 votes 0 votes srestha commented Jan 27, 2018 reply Follow Share sorry computer making problem 0 votes 0 votes Please log in or register to add a comment.