1 votes 1 votes what will be the output(how many tupples) Databases databases sql + – gari asked Jan 18, 2018 gari 1.3k views answer comment Share Follow See all 12 Comments See all 12 12 Comments reply Show 9 previous comments joshi_nitish commented Jan 18, 2018 reply Follow Share bhavnae samjho, sabdo me kya rakha hai :P 2 votes 2 votes Chirag arora commented Jan 18, 2018 reply Follow Share How it is 4 , as value of C should be equal to all the values of subquery , m not getting 0 votes 0 votes Kiran Karwa commented Jan 18, 2018 reply Follow Share @nitish =ALL will always return false right if that subquery returns two/more distinct values? and had this been asked as =ANY then it will return 0 ? 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes 0 tuples will be selected. Avik Chowdhury answered Mar 19, 2018 Avik Chowdhury comment Share Follow See all 2 Comments See all 2 2 Comments reply abhishekmehta4u commented Mar 19, 2018 reply Follow Share 4 tuples are selected. Becz all clause is true in case empty set 1 votes 1 votes akshat sharma commented Mar 20, 2018 reply Follow Share yes in case of ALL if every tuple is giving false answer then it will return all rows of table ike in above case 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes All will be returned Psy Duck answered Oct 30, 2022 Psy Duck comment Share Follow See all 0 reply Please log in or register to add a comment.