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 you sum a count in sql?

1059

What does stand for in sql?

1020

Why stored procedure is faster than query?

1150

Can procedure in package be overloaded?

1138

What is union?

1248

What is autocommit sql?

1039

Can a table contain multiple primary key’s?

1153

How many sql statements are used?

1067

What is the difference between database trigger and stored procedure?

1133

Does sql require a server?

1055

What is out parameter used for eventhough return statement can also be used in pl/sql?

1121

what is difference between delete and truncate commands? : Sql dba

1167

What is query optimization in sql?

1040

how to create a table index in mysql? : Sql dba

1117

what is foreign key? : Sql dba

1100