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 to move files from one directory to another in pl sql?

1184

explain the difference between myisam static and myisam dynamic. : Sql dba

940

What is AUTH_ID and AUTH_USER in pl/sql ?

2180

how to create a new table by selecting rows from another table in mysql? : Sql dba

1080

Explain ddl statements in pl/sql?

1003

What is data profiling in sql?

1069

can sql servers linked to other servers like oracle? : Sql dba

1000

What are crud methods?

1023

Explain the working of foreign key?

1058

What is the difference between a primary key and a clustered index?

982

What is view? Can we update view

1425

How do I start sql profiler?

989

write an sql query to find names of employee start with 'a'? : Sql dba

1022

What type of database is cloud sql?

1092

Why schema is used in sql?

1044