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 is single byte over head in oracle..?

2337

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3007

What are primary key and foreign key and how they work?

924

What are the different types of triggers?

1048

what is the bond code in materialized view?

2930

how to get help information from the server? : Sql dba

874

Enlist some predefined exceptions?

990

What does dml mean?

927

What is bind reference and how can it be created?

965

What is a sql statement?

898

How do you explain an index?

1221

Does mysql_real_escape_string prevent sql injection?

906

What is the sql*loader? : aql loader

1003

What is a constraint? Tell me about its various levels.

1081

What is use of term?

1006