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

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

Question Posted / raj

Answer Posted / raj

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

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to delete a column in an existing table?

1070

How to change system global area (sga) in oracle?

1003

How many types of auditing in Oracle?

1026

How do you tell what your machine name is and what is its IP address?

2087

Explain about achiever in sql?

1023

what are steps for interface? where is exchange rate defined in which table?

2145

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2124

Why use resource manager in Oracle?

1100

How to use windows user to connect to the server?

985

Can you have more than one content canvas view attached with a window ?

2324

What is proxy method?

965

What's dateware house and what's clustor with practicle example

2165

What is PL/SQL ?

2039

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2205

Is postgres faster than oracle?

1016