Can we use more than one null value for unique key?
Answer Posted / debdut bhaumik
Yes , More than one field can be NULL in a unique Key
column. Because a Null values is not equal to another null
value. So, no duplicate value is there.
| Is This Answer Correct ? | 26 Yes | 12 No |
Post New Answer View All Answers
Can there be 2 primary keys in a table?
Why are sql stored procedures used?
What sql does db2 use?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
how to include comments in sql statements? : Sql dba
what is a unique key ? : Sql dba
Is not null in sql?
How does pl sql work?
Is it possible for a table to have more than one foreign key?
Is sql microsoft?
What is full join?
Why do we need pl sql?
Can we use ddl statements in stored procedure sql server?
what is a constraint? : Sql dba
What are sql functions? Describe in brief different types of sql functions?