select * from emp where null=null: will not return any rows in the table

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

Question Posted / anitha

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to run create database statement?

975

What is MTTR advisor in Oracle?

1033

What are the uses of linked server and explain it in detail?

1000

Explain an index segment?

1039

What do you mean by merge in oracle and how can we merge two tables?

1000

How to delete a column in an existing table in oracle?

1008

What is rowid and rownum in oracle?

951

How to connect to a local oracle 10g xe server?

935

What is the quickest way to fetch the data from a table?

999

How do I know if oracle client is installed on windows?

952

Explain oracle’s server parameter file.

946

What is a initialization parameter file in oracle?

986

How to use subqueries in the from clause in oracle?

1043

Which is better Oracle or MS SQL? Why?

4823

What is meant by a deadlock situation?

1049