what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 18061 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
Answer Posted / samir kumar sahoo
select*from emp where null=null;
this command will not return any record bcoz the
condition null=null false as two null values are not equal.
select*from emp where 1=1;
will return all the records present in the table emp as
the condition 1=1 is always true.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a lookup table in oracle?
What suggestions do you have to reduce the network traffic?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to insert a record into a table?
How to add a new column to an existing table in oracle?
How to retrieve values from data fields in record variables?
What is the relation of a user account and a schema in oracle?
Point out the difference between user tables and data dictionary?
How to open a cursor variable?
What happens in oracle commit?
WHAT IS ecc 6.0
State the various uses of dbcc command?
What is rich query?
How different is ms access and oracle?
How to resolve name conflicts between variables and columns?
