Distinct: Its gives only the non duplicate values in a database table. Un

Differences between UNIQUE and DISTINCT in select statements

Question Posted / prabha

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

Answer Posted / prabha

Distinct:
Its gives only the non duplicate values in a database table.
Unique:
The UNIQUE constraint uniquely identifies each record in a
database table.its similar to primary key.these values
cannot be repeated.

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why is sql important?

1109

What is the purpose of cursors in pl/sql?

1136

How do I view stored procedures?

975

What is sqlservr exe?

978

How do I order columns in sql?

1007

what is csv? : Sql dba

999

What is over () in sql?

965

explain what is mysql? : Sql dba

1082

What is native sql query?

1025

How do we accept inputs from user during runtime?

1065

which tcp/ip port does sql server run on? : Sql dba

1026

what is row? : Sql dba

1228

Is left join same as inner join?

1130

Is there a 64 bit version of ssms?

961

What is cursor explain with example?

987