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
- 24816 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 can delete duplicate records in cte in sql server?
What is order of B+tree?
Difference between group by clause and having clause in SQL?
How to see the event list of an existing trigger using sys.trigger_events?
what is bit datatype? : Sql server database administration
Explain the third normal form(3nf)?
Explain iaas, paas and saas?
What is transaction server explicit transaction?
What is the use of tempdb? What values does it hold?
What is precedence constraint?
Explain indexing and what are the advantages of it?
what does the automatic recovery do? : Sql server administration
What is difference between order by and group by?
What happens if you delete a table that is used by a view?
Write a query for primary key constraint with identity key word?
