0 votes 0 votes Niharika 1 asked Nov 20, 2017 Niharika 1 637 views answer comment Share Follow See all 10 Comments See all 10 10 Comments reply Show 7 previous comments joshi_nitish commented Nov 20, 2017 reply Follow Share then count(*) would return 3 1 votes 1 votes Hemant Parihar commented Nov 20, 2017 reply Follow Share @akash.dinkar12 Please see my comment below the answer, Can you explain why the output is 3? As you said Null comparison with Null is considered as different. 0 votes 0 votes akash.dinkar12 commented Nov 20, 2017 reply Follow Share see this... 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes its C Akash Mittal answered Nov 20, 2017 Akash Mittal comment Share Follow See all 3 Comments See all 3 3 Comments reply Hemant Parihar commented Nov 20, 2017 reply Follow Share You did a typo while inserting into the table see this. 0 votes 0 votes joshi_nitish commented Nov 20, 2017 reply Follow Share @Hemant in your's SQL engine is ANSII NULL is set off ? because, then only it will give 3. 1 votes 1 votes Hemant Parihar commented Nov 20, 2017 reply Follow Share @joshi Don't know. There is no such option. 0 votes 0 votes Please log in or register to add a comment.