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 constant in pl sql?

1026

Why is there a need for sqlcode and sqlerrm variables?

1053

Is sql a microsoft product?

954

Explain the order of sql statement execution?

1049

How delete a row in sql?

998

Which are sql * plus commands?

1132

Is sql low level language?

1022

How do I create a sql database?

1004

What is substitution variable in pl sql?

1051

Explain what is a subquery ?

1190

How do I audit the sql sent to the server?

1012

What is a variable in sql?

1005

What is sql basics?

1046

What does the file extension accdb stand for?

972

Is json a nosql?

984