what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 18083 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
Answer Posted / anitha
select * from emp where null=null: will not return any rows
in the table since two null values are not always same.
select * from emp where 1=1 : will return all the rows in
the table because 1 is always equal to 1.
| Is This Answer Correct ? | 36 Yes | 1 No |
Post New Answer View All Answers
How to calculate date and time differences in oracle?
Is it possible to split the print reviewer into more than one region ?
How to loop through data rows in the implicit cursor?
how to do daily transactions with out sql* loader control file regesterd in apps?
Can we use bind variables in oracle stored procedure?
Can the query output be sorted by multiple columns in oracle?
What does sharding mean?
Which is better Oracle or MS SQL? Why?
What is Data Dictionary Cache in Oracle?
How do I know if oracle client is installed on windows?
What is the maximum number of triggers that can be applied to a single table?
What is a data dictionary and how can it be created?
Explain index?
How to synchronize 2 schema's objects?
What are the original export and import utilities?
