2 votes 2 votes richa116 asked Nov 29, 2015 richa116 367 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes Here ans will be (c)1 inner query first executed i.e. select manager from emp ; and this fetches 2,3,4 Now, outer query will be executed and the rows of eno.=2 or 3 or 4 will not be prined So, it only prints eno ename manager 1 a 2 srestha answered Nov 29, 2015 • edited Nov 29, 2015 by srestha srestha comment Share Follow See all 3 Comments See all 3 3 Comments reply richa116 commented Nov 29, 2015 reply Follow Share According to ans key : is It correct!!! 0 votes 0 votes Arjun commented Nov 29, 2015 reply Follow Share I don't think that key is correct. You can try on a DBMS.. 0 votes 0 votes srestha commented Nov 29, 2015 reply Follow Share yes, I think NULL cannot make any change here. 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes ans d is correct....whenever not in operator compare with null value condition become false....so no row is selected... Tarani Behera answered Dec 7, 2015 Tarani Behera comment Share Follow See all 0 reply Please log in or register to add a comment.