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

Why do we need unique key in a table?

673

What is the least restrictive isolation level? : Transact sql

768

Is record in oracle pl sql?

699

Does sql between include endpoints?

750

Is sql a scripting language?

693

What is the maximum number of triggers, you can apply on a single table?

742

How many sql statements are used? Define them.

780

How many scalar data types are supported in pl/sql?

721

What is dbo in sql?

710

What is a temporal data type?

777

How can one get sql*loader to commit only at the end of the load file? : aql loader

753

How do I run a program in pl sql?

703

What is schema in sql example?

827

Can we insert data in view?

691

What is compilation error in pl sql?

703