what is the output of select * from emp where null=null & select * from em

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

what is the output of select * from emp where null=null &
select * from emp where 1=1

Question Posted / kalyani

8 Answers
17933 Views
IMS Health, NIIT, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the output of select * from emp where null=null & select * from emp where 1=1..

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

what is the output of select * from emp where null=null & select * from emp where 1=1..

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

what is the output of select * from emp where null=null & select * from emp where 1=1..

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

what is the output of select * from emp where null=null & select * from emp where 1=1..

Answer / raj

Null=Null returns no row but 1=1 returns entire row of the
table.

Is This Answer Correct ?

2 Yes

0 No

what is the output of select * from emp where null=null & select * from emp where 1=1..

Answer / samir kumar sahoo

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

what is the output of select * from emp where null=null & select * from emp where 1=1..

Answer / kumar

Really Good Answer Anitha Madam.

By
Kumar.T

Is This Answer Correct ?

3 Yes

2 No

what is the output of select * from emp where null=null & select * from emp where 1=1..

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

what is the output of select * from emp where null=null & select * from emp where 1=1..

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

Post New Answer