Interested to Buy Any Domain ? << Click Here >> for more details...
what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 19518 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 create an oracle database manually?
What is clustered table in Oracle?
How to resolve the ORA-39133 error in Oracle?
what is insert all statement in sql
How does the on-delete-cascade statement work?
How to convert numbers to characters in oracle?
What is the difference between PFILE and SPFILE in Oracle?
Whether any commands are used for months calculation? If so, what are they?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Explain the use of online redo log files in oracle.
What is the use of aggregate functions in oracle?
How to sort output in descending order in oracle?
What are the arithmetic operations?
What is the difference between sharding and partitioning?
State the difference between a primary key and foreign key?
