0 votes 0 votes Databases made-easy-test-series databases sql + – pranab ray asked Dec 20, 2017 • edited Mar 7, 2019 by Aditi Singh pranab ray 464 views answer comment Share Follow See all 7 Comments See all 7 7 Comments reply Ashwin Kulkarni commented Dec 20, 2017 reply Follow Share All 3 tuples. 0 votes 0 votes SHUBHAM SHASTRI commented Dec 20, 2017 reply Follow Share yes all 3 tuples ... exist return true if inner query returns at least one tuple.. here for 2 we have count = 0 .. so all 3 tuples are output. 0 votes 0 votes Shubhanshu commented Dec 20, 2017 reply Follow Share "count(*)" will never return null instead it returns 0. And Thus exists() along with count(*) always remains true. 0 votes 0 votes pranab ray commented Dec 20, 2017 reply Follow Share SHUBHAM SHASTRI HOW you are getting for 2 count as 0 actually i am getting for 6 count as zero 0 votes 0 votes SHUBHAM SHASTRI commented Dec 20, 2017 reply Follow Share yes ..you are correct.. i went wrong there .. 0 votes 0 votes pranab ray commented Dec 20, 2017 reply Follow Share shubham as count is writing 0 then also exist will be true .... means in case of any integer it true is it ? 0 votes 0 votes SHUBHAM SHASTRI commented Dec 20, 2017 reply Follow Share yes .. 0 votes 0 votes Please log in or register to add a comment.