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 are different types of locks?
What is the use of aggregate functions in oracle?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep
What is the difference between an Oracle Schema and an Oracle Instance?
What is a connect identifier?
25. Display the client number and the value of the highest value order placed by that client.
Why do we need oracle client?
In Oracle 10g, "g" Stands for what?
what is the syntax of UPDATE command?
what is index?
Is insert autocommit in oracle?