Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 130809 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
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
What is serial sql?
Can we use loop in sql?
What are the sql versions?
How is data stored in sql?
How exception handling is done in advance pl/sql?
How many types of literals are available in pl sql?
what is a trigger? : Sql dba
What is the usage of the distinct keyword?
how to rename an existing column in a table? : Sql dba
Is inner join faster than left join?
what is a control file ? : Sql dba
What is hibernate and its relation to sql?
What is percent sign in sql?
What is sap sql anywhere?
