Hi Howard Cheon, you are currect... but we cant able to use

Differences between UNIQUE and DISTINCT in select statements

Question Posted / vijay mohan reddy

26 Answers
135450 Views
ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
E-Mail Answers

Answer Posted / vijay mohan reddy

Hi Howard Cheon,
you are currect... but we cant able to use
both DISTINCT and UNIQUE, if the select_list contains LOB,
LONG columns. It may not a difference.

Could anyone plz give some another major difference..

Thanks in Advance

Vijay Reddy.

Is This Answer Correct ?

9 Yes

10 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is percent sign in sql?

1278

What is the difference between in and between in sql?

1050

How can I change database name in sql?

1062

What are the query optimization techniques?

923

Which table is left in left join?

1001

How do you use join?

930

Is mariadb a nosql database?

1042

What are three advantages to using sql?

1000

What is identity column in sql server?

1038

How delete all data from all tables in sql?

939

How do I run a program in pl sql?

994

what is sql server agent? : Sql dba

1093

What is the maximum number of rows in sql table?

1017

What is a trigger word?

1014

What is sql server and ase?

1012