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

Is sql a programming?

933

Why indexing is needed?

939

How to prepare for oracle pl sql certification?

1010

How do I view a sql trace file?

960

Can we enter data in a table in design view?

911

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

931

What is indexing in sql and its types?

1004

What is sql select statement?

969

What is sqlca in db2?

890

how can we repair a mysql table? : Sql dba

914

How many rows can sqlite handle?

1047

Explain how to use transactions efficiently : transact sql

923

How do you concatenate in sql?

973

How to run pl/sql statements in sql*plus?

1021

What is basic structure of pl sql?

985