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
- 24335 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
What are the elements of dbms?
What are the difficulties faced in cube development? : sql server analysis services, ssas
Is the log file is a part of file group?
How to call a function from a stored procedure in SQL Server ?
Tell me what do we need queues in sql service broker?
Can you pass expressions to stored procedure parameters?
What are the tool windows in sql server management studio? : sql server management studio
What is the use of nvl work?
Explain difference between control flow and data flow?
Why use triggers?
Explain about the command-line tool SQLCMD?
Detail about the hardware which is supported by SQL server?
How to apply cascading referential integrity in place of triggers?
What is after dml trigger?
Can you explain important index characteristics?
