in first case it would response and it will show error and in second case

what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;

Question Posted / rohit

Answer Posted / rohit

in first case it would response and it will show error and
in second case it will show object belonging to first row
and column

Is This Answer Correct ?

4 Yes

29 No

Please Help Members By Posting Answers For Below Questions

What is the data tier application?

169

Explain trigger and trigger types?

1034

How would you use user_constraints table in DB?

1059

What is the cpu pressure?

1107

How do database indexes work?

1055

How to add a new dsn with the odbc driver for sql server?

1112

Explain what is use of dbcc commands?

1131

What stored by the msdb?

1046

What are basics of policy management?

1150

How does a profiler work?

993

Explain the collation?

1146

What are key constraints?

1015

What is an identity?

1076

What are a database and a data warehouse?

1071

What were the latest updates to SQL Azure service?

113