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

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

894

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

919

How does pl sql work?

723

how to shut down the server with 'mysqladmin'? : Sql dba

764

what is the difference between rownum pseudo column and row_number() function? : Sql dba

841

what is a constraint? : Sql dba

900

What is number function in sql?

736

Is pl sql and postgresql same?

807

Define select, insert, create, delete, update, drop keywords

798

What is record type in pl sql?

779

Are there any features that are decommissioned in 11g that are not present in 11g?

1859

What is the use of function "module procedure" in pl/sql?

916

what is the bond code in materialized view?

2709

What is trigger in pl sql with examples?

768

what is query cache in mysql? : Sql dba

794