what is the output of select * from emp where null=null &
select * from emp where 1=1
Answers were Sorted based on User's Feedback
Answer / anitha
select * from emp where null=null: will not return any rows
in the table since two null values are not always same.
select * from emp where 1=1 : will return all the rows in
the table because 1 is always equal to 1.
Is This Answer Correct ? | 36 Yes | 1 No |
Answer / anee desai
first command will give no records whereas 2nd command will
provide all records as 1 is equal to one.it is similar to
select * from emp;.if 2=2 will also provide the same
result.it makes no sense in writing 1=1;
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / shree
first command will give no records whereas 2nd command will
provide all records as 1 is equal to one.it is similar to
select * from emp;.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / raj
Null=Null returns no row but 1=1 returns entire row of the
table.
Is This Answer Correct ? | 2 Yes | 0 No |
select*from emp where null=null;
this command will not return any record bcoz the
condition null=null false as two null values are not equal.
select*from emp where 1=1;
will return all the records present in the table emp as
the condition 1=1 is always true.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / chandana
NULL = NULL ...NOT TRUE
NO ROWS RETURNED
1=1 ...TRUE
ALL ROWS RETURNED
1=2....NOT TRUE
NO ROWS RETURNED
2=2,3==3 AND SO ON WILL RETURN ALL ROWS FROM A TABLE
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / bhavish
1.statament "no rows select"
2.statament "the 14 rows displayed
why because the true condition and null values are different
Is This Answer Correct ? | 0 Yes | 0 No |
What is format trigger?
What is the difference between post-database commit and post-form commit?
What is the data pump import utility?
How many data types are supported?
What are the advantages of oracle 12c?
How to create a new oracle data file?
What is Database Trigger ?
How to run create database statement?
Does oracle charge for java?
What are joins, explain all types of joins?
Why is oracle database so popular?
How to create a stored function in oracle?