what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 18006 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
Explain the use of owner option in exp command.
What is meant by joins? List out the types of joins.
What is SQL access advisor in Oracle?
Why do we need oracle client?
What is rowid and rownum in oracle?
What is the sql query to concatenate column values from multiple rows in oracle?
What types of joins are used in writing subqueries?
How to invoke the data pump import utility?
Explain an index?
How to calculate date and time differences in oracle?
How to install oracle database 10g xe?
How to bring a tablespace offline?
How to run create database statement again?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Differentiate between post-database commit and post-form commit?
