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 |
How will you monitor replication latency in transactional replication? : sql server replication
What is after dml trigger?
What's new in sql management studio for sql server? : sql server management studio
How to Handle the exceptions in Sqlsrver 2005??
How to run sql server 2005 books online on your local system?
how many instance use in sql server 2005
What are tables in sql server?
How to use values from other tables in update statements in ms sql server?
What's the difference between a primary key and a unique key?
What is the difference between the application object and session object?
What is tabulation?
How to list all dsn entries on your local machine using odbc_data_source()?