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

What is difference between hql and native sql?

1172

What is AUTH_ID and AUTH_USER in pl/sql ?

2193

what is auto increment? : Sql dba

1008

What are the various restrictions imposed on view in terms of dml?

965

What is the process of copying data from table a to table b?

1091

How can a function retun more than one value in oracle with proper example?

1074

What is sql in oracle?

1061

What are the benefits of pl/sql packages?

1107

What is a native sql query?

1069

Does sql between include endpoints?

1012

What is sql engine in oracle?

989

Is pl sql different from sql?

999

What is exit statement?

1016

Does sap use sql?

994

How would you reference column values before and after you have inserted and deleted triggers?

1065