select*from emp where null=null; this command will not return any reco

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

Question Posted / samir kumar sahoo

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to use "out" parameter properly?

1076

interview questions with answer for cts

2578

Explain the use of log option in exp command.

1108

Compare and contrast between sql and sql server and explain its various functions?

953

What is sharded cluster?

1003

How index is implemented in oracle database?

996

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5399

Explain an exception and its types?

1065

How can we force the database to use the user specified rollback segment?

1138

What is the difference between sharding and partitioning?

982

What is meant by recursive hints in oracle?

1082

Can a parameter be passed to a cursor?

1111

How do I escape a reserved word in oracle?

1193

How to assign a tablespace to a users in oracle?

1042

Whats the benefit of dbms_stats over analyze?

1993