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
- 24220 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
How do we know if any query is retrieving a large amount of data or very little data?
How to concatenate two binary strings together?
Where do we use trace frag?
What is PROJECTION Operation?
How to Check if table exists in sql server?
What does asynchronous call backs means?
Can we write ddl in trigger?
Can you always create a cache of a report?
What are the advantages of sql azure?
Which rendering formats are affected by the pagesize properties?
Write the syntax for stuff function in an sql server?
What is difference between line feed ( ) and carriage return ( )?
What are orphan records?
How do I view a procedure in sql server?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
