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
- 24350 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
What is the function of inner join?
If no size is defined while creating the database, what size will the database have?
What are the requirements for sql server 2016?
What is sql injection? How to protect against sql injection attack?
What does sql server mean?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
How to use group functions in the select clause in ms sql server?
Why do we backup Active Directory ?
What is database replication? What are the different types of replication you can set up in sql server?
What is a matrix in ssrs?
What is a trace frag?
What have included columns when we talk about sql server indexing?
what happens on checkpoint? : Sql server database administration
What protocol does sql server use?
What is instead of dml trigger?
