unique is a constraint on coloumnsbut distinct is used in DML for query ret

Differences between UNIQUE and DISTINCT in select statements

Question Posted / carol

Answer Posted / carol

unique is a constraint on coloumnsbut distinct is used in DML for query retrieval in select

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I run a query in pl sql developer?

925

What is not in sql?

897

What is the reports view in oracle sql developer?

924

How to raise user-defined exception with custom sqlerrm ?

1060

Why do we need view in sql?

931

What is the use of <> sql?

929

What is the difference between local and global temporary table?

986

Can you join a table to itself?

1029

How does postgresql compare to mysql?

984

what is oltp (online transaction processing)? : Sql dba

1010

Is sql procedural language?

919

What are the different sql commands?

1000

Which nosql database is best?

915

What is over () in sql?

890

How do I view an execution plan in sql?

919