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
- 23799 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / rohit
in first case it would response and it will show error and
in second case it will show object belonging to first row
and column
| Is This Answer Correct ? | 4 Yes | 29 No |
Post New Answer View All Answers
Difference between aggregate functions of sql?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What are magic tables in sql server?
What are policy management terms?
What is key attribute?
What is self contained scalar sub query?
How can you control the amount of free space in your index pages?
How to insert and update data into a table with "insert" and "update" statements?
What are the advantages of using stored procedures in sql server?
What is the difference between functions and scalar functions?
What is difference between order by and group by?
What are the five characteristics of good data?
What are the triggers in sql?
Explain sql delete command?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
