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
- 24807 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 difference between rank and dense_rank?
Can select statements be used on views in ms sql server?
What is default constraint?
How you can get the list of largest tables in a database?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What do you mean by subquery?
Define model database?
Do you know what are the ways available in sql server to execute sql statements?
What is the server name in sql server?
What stored by the tempdb ? : sql server database administration
What is dknf in normalization form?
What are wait types?
what stored procedure would you use to view lock information? : Sql server administration
how will add additional conditions in sql?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
