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

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

970

What do you mean by dbms? What are its different types?

1018

Is delete faster than truncate?

1002

What are the different sql languages?

1035

How many sql core licenses do I need?

944

what are the different tables present in mysql? : Sql dba

984

What is dynamic query?

974

How to add a column ‘salary’ to a table employee_details?

1012

Can a commit statement be executed as part of a trigger?

1048

explain normalization concept? : Sql dba

1045

Can you load data into multiple tables at once? : aql loader

1066

What is tuple in sql?

1078

Why do we go for stored procedures?

1057

What is a full join?

983

Is the primary key an index?

1026