Can we use more than one null value for unique key?
- 31 Answers
- 59883 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
What is user in sql?
Is sql a dbms?
How do I save a sql query?
How do I view tables in sql developer?
What is pl sql commands?
Which constraints we can use while creating database in sql?
What is lookup table in sql?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What is %type in pl sql?
What is the purpose of my sql?
What are the possible values that can be stored in a boolean data field?
What is the advantage of nosql?
Which is better varchar or nvarchar?
what is 'trigger' in sql? : Sql dba
Can we join more than 2 tables in sql?
