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
136457 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

Write an sql query to select all records from the table?

1076

What is sql*loader and what is it used for?

1218

What is package in pl sql?

1083

Explain the insert into statements in sql?

1052

Is stored procedure faster than query?

1019

Why is a trigger used?

991

How to select unique records from a table?

1109

Explain dml and ddl?

1056

How do I restart sql?

1025

Which normal form is best?

997

What is a table partition?

1205

Explain unique key in sql.

1060

What are the different type of joins in sql?

997

What are the different types of triggers?

1191

Which are sql * plus commands?

1201