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

What is transaction server distributed transaction?

1054

Define primary key?

1138

What is GUID in sql server?

1165

Can you explain what is indexed view? How to create it?

904

Explain “@@rowcount” and “@@error” in sql server?

1089

What are the encryption mechanisms in sql server?

1028

What is TDS(Tabular Data Stream) Gateway?

121

how to invoke a trigger on demand? : Sql server database administration

1086

What are the difference between primary keys and foreign keys?

966

How can I tell if sql server is 32 or 64 bit?

961

System requirements for sql server 2005 express edition?

1018

Explain primary key in sql server?

1016

Define inner join? Explain with an example?

996

How to create a ddl trigger using "create trigger" statements?

1131

What is difference between getdate and sysdatetime in sql server 2008?

1047