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
- 24920 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / gowthami radhakrishnan
a)in the first case there is no output only the column
names alone is displyed
b)in this case all rows will be displayed even for
1=1,2=2,3=3,..........
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is extent? Types of extents?
What is the difference between left and right outer join?
How do I run sql server 2014?
what's the information that can be stored inside a bit column? : Sql server database administration
What is key set driven?
What is the difference between drop table and truncate table?
How do I create a stored procedure in dbml?
What the difference between UNION and UNIONALL?
what are database files and filegroups? : Sql server database administration
Where actually sql azure database is hosted?
Explain what are commit and rollback in sql?
What is the difference between DATETIME2 and DATETIME?
Explain use of expression builder.
What is the difference between Clustered and Non-Clustered Index?
What is query optimizer in sql server?
