what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
Answers were Sorted based on User's Feedback
Answer / poonam
First Query : will return all columns name without any data.
Second Query :will display all the records which are available in the table.bez Select* from emp where 1=1; the condition is true.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / 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 |
What is difference between unique and primary key?
What xml support does the sql server extend?
hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000
What do you understand by check constraint in sql server?
How to get max 100 values from sql server
What is subquery in sql?
What is a group function explain with an example?
What is the use of floor function in sql server?
How do I start sql server 2016?
When you first load SQL SERVER you will startup with what all databases?
What are group functions in query statements in ms sql server?
can you any body tell me the how to decrease the logfile