Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 131464 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / gvmahesh
unique is a constraint it's declare for preventing the data
duplication.we create it along with table creation.
DISTINCT is a clause it is used for retrieving the data
without duplication.but it can't prevent the data
duplication.It just hiding the duplicated data.
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
In what condition is it good to disable a trigger?
How do you create an update query?
Can we use insert statement in function?
What is oracle sql developer?
Is sqlite good enough for production?
Mention what pl/sql package consists of?
Does inner join return duplicate rows?
How to disable a trigger name update_salary?
What does count (*) do in sql?
How to use sql*plus built-in timers?
What is trigger types in sql?
how to create a new view in mysql? : Sql dba
What is join view in sql?
How to load data with sql*loader?
Can you load data into multiple tables at once? : aql loader
