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 is a scalar value in sql?

1019

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1223

difference between anonymous blocks and sub-programs.

1084

Is sql an operating system?

973

When is a declare statement required?

1091

What are views in sql?

934

how to run 'mysql' commands from a batch file? : Sql dba

1075

What does partition by mean in sql?

916

What is cursor and why it is required?

1117

Can we join same table in sql?

969

What is a clob in sql?

976

Can we alter stored procedure?

949

what is sql? : Sql dba

977

How do I view a view in sql?

899

Why partition by is used in sql?

977