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 triggers and its uses?

1093

Can we edit a view in sql?

1032

What is sql profiler in oracle?

1153

what is cross join? : Sql dba

1041

Does inner join return duplicate rows?

1034

What is raid? How does it help storage of databases?

1127

What is a heap in sql?

1130

What does subquery mean in sql?

1108

What is fmtonly in sql?

1154

Is a secondary key the same as a foreign key?

1108

What is trigger explain it?

1073

what is a trigger in mysql? : Sql dba

1197

What are the two types of periodical indexes?

985

What do you understand by exception handling in pl/sql?

1083

Differentiate pl/sql and sql?

1119