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
- 24910 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / jay vardhan singh
select * from Emp where null = null;
null can not be equal to null.So,Condition is not satisfied.
So,it will give only column name.
select * from Emp where 1=1;
1 is always equal to 1.So,Condition is satisfied ,So It
will give all data which is present in table.
| Is This Answer Correct ? | 23 Yes | 1 No |
Post New Answer View All Answers
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What is user-defined function?
Explain the etl (extraction, transformation, and loading)?
How can sql server instances be hidden?
What is bit data type? What's the information that can be stored inside a bit column?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What is partition in sql server?
What is faster join or union?
What is the Disadvantage of indexed sequential file.
What are scheduled tasks in sql server?
How to select some specific rows from a table in ms sql server?
what data regions are and what are the different data regions?
What is the main purpose of having conversation group?
How to find the list of fixed hard drive and free space on server?
what is the difference between Delete and Truncate command in SQL
