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
- 23798 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / poonam
First Query : will return all columns name without any data.
Second Query :will display all the records which are available in the table.bez Select* from emp where 1=1; the condition is true.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain following error properties?
How many types of subqueries are there in sql server?
What is scrollable cursor?
What do you mean by data integrity?
What is optimistic concurrency?
What are the types of sql server?
What are the kinds of subquery?
How do you open a cluster administrator?
What is the data tier application?
What is difference between primary key and foreign key?
What is report snapshot?
How to find table changes in sql server?
What is table-valued sub query?
Where can you add custom error messages to sql server?
What is the difference between clustered and non-clustered indexes in ms sql server?
