Differences between UNIQUE and DISTINCT in select statements
Answer Posted / vidya
unique allows null value but distinct does not consider
null value
| Is This Answer Correct ? | 2 Yes | 44 No |
Post New Answer View All Answers
Can we connect to postgresql using sql developer?
How do I save a sql query?
What is mutating table error?
Which are the different character-manipulation functions in sql?
what is sub-query? : Transact sql
What is normalization? How many normalization forms are there?
When sql appeared?
Can a foreign key be a duplicate?
How does an execution block start and end in pl sql?
Is join and inner join the same?
What is an inner join sql?
How does postgresql compare to oracle/db2/ms sql server/informix?
What is the use of partition by in sql?
How to create a menu in sqlplus or pl/sql?
Can a foreign key be null?