what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
- 13 Answers
- 21460 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
How to find the service pack installed? : sql server database administration
Explain data warehousing in sql server?
What are the drawbacks of reporting in ssrs?
Write down the syntax and an example for create, rename and delete index?
What is 1nf 2nf?
What is the difference between a fill factor of 100 and 0?
What is a print index?
How to create a new login name in ms sql server?
What is order of B+tree?
Explain about sql server login?
What do you understand by the analysis services in sql server?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
What command is used to delete a table from the database in the sql server and how?
How to modify an existing stored procedure in ms sql server?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
