Interested to Buy Any Domain ? << Click Here >> for more details...
what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
- 13 Answers
- 24814 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / m@ngesh
in the first query There is no records to show in output
box only show the column name Like empname, city, address
etc..
and the second query say that there is all records are to
be show.when query (1=1) will be satisfied on the table
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the difference between left and right outer join?
What is the difference between local and global temporary tables?
Do you know what is sql service broker?
What is an execution plan?
How do I start sql server 2017?
How to disable a login name in ms sql server?
Which language is supported by sql server?
What is the difference between upgrade and migration in sql server?
What is the difference between locking and multi-versioning?
What is tabulation?
How much memory that we are using in Logshipping Concept?
Why do we need normalization?
What are the types of table?
What happens if strings are casted into wrong code pages in ms sql server?
When would you use sql joins?
