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 |
Is truncate autocommit in oracle?
Explain a synonym?
Draw E-R diagram for many to many relationship ?
How do you bind variables in oracle?
Differentiate between translate and replace?
Can we commit inside a function in oracle?
can we insert any row to dual table if i got the permission from DBA
What is a oracle database?
Can the default values be assigned to actual parameters?
Explain the types of exception?
what is exact difference between drop and truncate table.
Can multiple cursors being opened at the same time?