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
- 24413 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / jerry joseph
a. select * from Emp where null = null;
null = null will be always false.. so no rows returned..
change the query to "select * from Emp where null is null;"
to select all rows
b. select * from Emp where 1=1;
1 = 1 will be always true.. so all the rows are returned..
| Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
What is the new security features added in sql server 2014? : sql server security
What is the main difference between ‘between’ and ‘in’ condition operators?
Do you know what are the ways available in sql server to execute sql statements?
What is a sql join?
Which are ddl commands?
How do we Backup SQL Azure Data?
Explain how dts is used to extract, transform and consolidate data?
What are truncate options available in sql server? : sql server database administration
Are null values the same as that of zero or a blank space?
Please explain go command in sql server?
Define Unique Key?
What are the different normalization forms?
What is built-in/administrator?
What is 5nf in normalization form?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
