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 insert command in sql?

1118

When is a declare statement required?

1134

What is mdb stand for?

1003

How do you get column names only for a table (sql server)?

1148

Explain what is a subquery ?

1180

What is sql*loader and what is it used for? : aql loader

1162

How do I start sql from command line?

1013

How show all rows in sql?

1006

where are cookies actually stored on the hard disk? : Sql dba

1021

What is package in pl sql?

1007

What does bitemporal mean?

1056

What is pl sql variable?

975

Is sql microsoft?

1038

What is the difference between a primary key and a clustered index?

980

What are sql indexes?

990