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 feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

1003

How to list all login names on the ms sql server?

1189

Give the query of getting last two records from the table in SQL SERVER?

1013

What do you mean by data manipulation language?

1064

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1130

What is TDS(Tabular Data Stream) Gateway?

127

what is normalization? : Sql server database administration

1163

What is the primary use of the model database?

1134

How to use copy and concatenate commands in SQL?

1203

How do I know if localdb is running?

1001

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

1016

What is buffer cash in sql server?

1206

How many columns can we include on clustered index ?

1060

What is difference between sql and sql server?

1081

What is for xml in sql server?

1140