1st Query Output is: SQL> select * from Emp where null = null; no

what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;

Question Posted / subbu

Answer Posted / subbu

1st Query Output is:

SQL> select * from Emp where null = null;

no rows selected

2nd Query Output is:

All the rows and columns of emp table

Is This Answer Correct ?

19 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can we call future method from queueable?

1044

What is the security model used in sql server 2005?

1004

How to update muliple row in single query?

1056

Do you know the different ddl commands in sql?

1048

Write a SQL command to insert and update only a particular field?

1108

What is 'write-ahead log' in sql server 2000 ?

1047

What is query processing?

935

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1096

Is it possible to replicate data from sql server to oracle? : sql server replication

1085

How to insert multiple rows with one insert statement in ms sql server?

1121

How many types of triggers in sql server?

1028

How to change the system date and time from SQL Plus Terminal ?

1216

How do I view a script in sql server?

1036

Explain Reporting Life Cycle?

129

What is global temp table?

992