We can insert any number of null values in the column which contains the

Can we use more than one null value for unique key?

Question Posted / anil kumar abbireddy

31 Answers
64302 Views
A1 Technology, Wipro, I also Faced
E-Mail Answers

Answer Posted / anil kumar abbireddy

We can insert any number of null values in the column which
contains the unique key
the reason is NULL is not equal to anothere NUll
so each null is different so there is no question of
duplication

Is This Answer Correct ?

140 Yes

30 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you remove duplicates without using distinct in sql?

930

Explain the difference between 'between' & 'and' operators in sql

958

Is there any restriction on the use of union in embedded sql?

1118

What are the advantages of sql? Explain

1061

What is synonyms?

1004

What is a sql instance vs database?

1051

Is primary key a clustered index?

923

What is index example?

963

how is myisam table stored? : Sql dba

1008

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1145

What are the different types of dbmss?

973

What is the use of double ampersand (&&) in sql queries? Give an example

1087

How can triggers be used for the table auditing?

1024

What are triggers in sql?

978

What are the various restrictions imposed on view in terms of dml?

922