Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 64153 Views
- A1 Technology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / arika
We can insert duplicate nul values in palce of using unique
key constrint.Because all nulls are not equal.
ex:-
select * from emp where comm=null;
explenation;
here equal operator not support null value because
all nulls are not equal
ex:-
select * from emp where comm is null;
explenation:
'is' operator suport null
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is a foreign key ? : Sql dba
Do prepared statements prevent sql injection?
Is join same as left join?
Is hadoop a nosql?
What is a rank in sql?
how to extract a unit value from a date and time? : Sql dba
What are different types of statements supported by sql?
How to run sql*plus commands in sql developer?
What are the sql aggregate functions?
Are dml statements autocommit?
Which is the correct statement about truncate and delete?
how to calculate the difference between two dates? : Sql dba
What is a composite primary key?
How delete all records from table in sql?
Does view contain data?
