How many null values can be inserted in a coulmn whihc is unique constraint
Answers were Sorted based on User's Feedback
Answer / sumit
Any number of Null values can be inserted in such a column.
Is This Answer Correct ? | 33 Yes | 7 No |
Answer / amit
Any no. of times you can insert null values in a coulmn
whihc is unique constraint because a Null value is
undefined,unassigned,and unapplicable value so thats why we
cannot compaire with any other null value or other value.
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / john bershan
any number of null value can be inserted into table for a
column which is declared as unique.coz null vale s either
not equal to any value or not equal to another null;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / manish kumar
Single null Value
B'cse Unique Constraint contain unique value and single
null is also a unique value.
Is This Answer Correct ? | 7 Yes | 29 No |
how to find 5th row ?
how to increment dates by 1 in mysql? : Sql dba
What are variables in pl sql?
What is sql stand for?
What is differance unique key and primary key.
What is the purpose of my sql?
What is cartesian join in sql?
What is an Integrity Constraint?
Is it possible to pass parameters to triggers?
Is primary key an index?
What is the difference between delete and truncate commands?
table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004