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

How do you send email on SQL Server?

1040

What is the difference between DataRow.Delete() and DataRow.Remove()?

1213

Which are the olap features?

940

what data regions are and what are the different data regions?

141

How to optimize stored procedure optimization?

879

What are different types of views?

931

What are the grouping functions?

920

What are dml (data manipulation language) statements in ms sql server?

965

How do I start sql server 2016?

880

How to loop through result set objects using mssql_fetch_array()?

1052

What are user defined functions in ms sql server?

975

What do you know about normalization and de- normalization?

909

What do you mean by SQL injection attack?

1041

What is the maximum rows in sql server table?

896

List the different normalization forms?

961