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
- 24830 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / anil patel
a. select * from Emp where null = null;
null= null is always false os no rows returns.
b. select * from Emp where 1=1;
it returns all rows
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is the maximum length of an alert name?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
Why use “nolock” in sql server?
How to set database to be read_only in ms sql server?
What is difference between cte and view?
What are the differences between clustered and non-clustered index?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is the use of custom fields in report?
What are trace flags and mention a few common trace flags used with sql server?
Can we insert data into a view?
What is the main purpose of having conversation group?
What is database mirroring?
What is the difference between truncate and delete commands?
How can I know what locks are running on which resource?
