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

Which are the two editions in which SQL Azure database available?

121

Differentiate between delete and truncate.

1123

Explain having clause?

1032

What is self contained scalar sub query?

1033

How many cores do I need for sql server 2016?

965

What is the new security features added in sql server 2016? : sql server security

1170

How to perform backup for certificates in sql server? : sql server security

1158

Mention the 3 ways to get a count of the number of records in a table.

1032

Explain the difference between cross join and full outer join?

1036

What is ssl in sql server?

1144

How many instances per computer are there in sql server 2000?

1132

Characterize join and name diverse sorts of joins?

1035

What are translations and its use? : sql server analysis services, ssas

1093

Which sql server table is used to hold the stored procedure scripts?

1115

What is default port number for sql server 2000?

1115