UNIQUE(Constraint):- Can be only once for a column in a table DI

Differences between UNIQUE and DISTINCT in select statements

Question Posted / manoj

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

Answer Posted / manoj

UNIQUE(Constraint):- Can be only once for a column in a
table

DISTINCT(Clause):- Useed in select query to retrive distinct
(non repeated) data from table(s)

Is This Answer Correct ?

114 Yes

68 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what is dbms?

1118

How to display the current date in sql?

1127

what happens if you no create privilege in a database? : Sql dba

1045

What is sql profiling in oracle?

1128

What is sql catalog?

1067

How to load data with sql*loader?

1110

How do sql databases work?

1043

Is sql pronounced sequel or sql?

1335

Explain what is rdbms?

1085

How can I change database name in sql?

1156

Why is sql better than hql?

1062

What are types of exception?

959

Explian rowid, rownum? What are the psoducolumns we have?

1045

What is the location of pre_defined_functions.

1208

What are types of joins?

1026