what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
Answer Posted / nitin yadav(nitin.yadav.india@
u can not compare two nulls
null means nothing.so
ANS 1:no row
ANS 2:All row (because of 1=1 is always true for all rows)
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is not null constraint?
What functions can a view be used to performed?
We need to perform what steps in the following order to work with a cursor?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
Explain the steps needed to create a scheduled job?
What is the purpose of forms?
Is the primary key column of a table an index in ms sql server?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
How many joins in sql server?
What is dirty page?
How to enforce security in sql server? : sql server security
What do you know about normalization and de- normalization?
Explain the different types of joins?
What are the basic features of a trigger in ms sql server?
What are indexes in sql?