there is no diff between distinct and unique in user point of view. both a

Differences between UNIQUE and DISTINCT in select statements

Question Posted / ajeet

Answer Posted / ajeet

there is no diff between distinct and unique in user point
of view. both are same. same functionality. dont bother
about it use whatever you want....

Is This Answer Correct ?

4 Yes

5 No

Please Help Members By Posting Answers For Below Questions

what are null values? : Sql dba

946

What is the use of pl/sql table?

1056

Write a query to find the names of users that begin with "um" in sql?

982

What does desc stand for?

1062

Is sql considered coding?

1036

What is hibernate and its relation to sql?

1113

How does cross join work in sql?

1007

What is difference between stored procedures and application procedures?

1004

what is the bond code in materialized view?

2995

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1004

What does pragma mean?

1043

Is coalesce faster than isnull?

960

How do I start sql profiler?

986

What is a mutating table and a constraining table?

1094

What is the process of debugging?

1059