unique allows null value but distinct does not consider null value

Differences between UNIQUE and DISTINCT in select statements

Question Posted / vidya

Answer Posted / vidya

unique allows null value but distinct does not consider
null value

Is This Answer Correct ?

2 Yes

44 No

Please Help Members By Posting Answers For Below Questions

Can we connect to postgresql using sql developer?

946

How do I save a sql query?

969

What is mutating table error?

1126

Which are the different character-manipulation functions in sql?

999

what is sub-query? : Transact sql

1050

What is normalization? How many normalization forms are there?

1022

When sql appeared?

1034

Can a foreign key be a duplicate?

867

How does an execution block start and end in pl sql?

907

Is join and inner join the same?

953

What is an inner join sql?

963

How does postgresql compare to oracle/db2/ms sql server/informix?

987

What is the use of partition by in sql?

938

How to create a menu in sqlplus or pl/sql?

1072

Can a foreign key be null?

1037