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

List out what other servers you can use with ssrs?

130

Why are you getting errors when creating a new odbc dsn?

1166

What do you mean by an execution plan? Why is it used?

952

What are the differences between user defined functions and stored procedures?

1004

What are audit control procedures?

940

What is difference between index and primary key?

1040

What are views used for?

967

Is a primary key unique?

939

What is RAID? What are the different types of RAID configurations?

1063

Explain Normalization and DE normalization

1053

What are the restrictions that views have to follow? : SQL Server Architecture

945

What is the difference between resultset and resultsetmetadata?

892

What are Spatial data types in SQL Server 2008

963

Scalability, Availability, Integration with internet, etc.)?

2821

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

112