DISTINCT AND UNIQUE are same operation. But, You cannot specify DISTINCT i

Differences between UNIQUE and DISTINCT in select statements

Question Posted / howard cheon

Answer Posted / howard cheon

DISTINCT AND UNIQUE are same operation.
But, You cannot specify DISTINCT if the select_list
contains LOB columns.

Is This Answer Correct ?

16 Yes

16 No

Please Help Members By Posting Answers For Below Questions

What are the parts of a basic sql query?

967

what is a materialized view? : Sql dba

1061

What are stuff and replace function?

1080

what is the difference between join and union? : Sql dba

1113

What is right join sql?

964

What is partition in sql query?

998

Which version of sql do I have?

1056

What is compute?

1088

Is sql database free?

975

Why do we need pl sql?

976

What is clustered index sql?

984

What is the difference between nested table and varray?

1003

Which table is left in join?

978

What are all the different normalization?

1037

What is the difference between left join and right join?

942