unique is a constraint on coloumnsbut distinct is used in DML for query ret

Differences between UNIQUE and DISTINCT in select statements

Question Posted / carol

Answer Posted / carol

unique is a constraint on coloumnsbut distinct is used in DML for query retrieval in select

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is orm in sql?

1046

What do you think about pl/sql?

1029

How to run pl/sql statements in sql*plus?

1079

Can we use loop in sql?

967

What are sql commands?

1010

How bulk collect improves performance?

1002

what is bdb (berkeleydb)? : Sql dba

1034

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1073

Can we call stored procedure in function?

957

What are the different types of a subquery?

1047

What does an inner join do?

1179

What is procedure explain with program?

1017

How do I clear the screen in sql plus?

1041

explain what is mysql? : Sql dba

1080

How do I run a sql query?

1016