Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135476 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
what's the difference between a primary key and a unique key? : Sql dba
How to use boolean type in select statement?
What are the different dcl commands in sql?
What is the process of debugging?
What is having clause in sql?
How do I enable sql encryption?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Is it possible to read/write files to-and-from PL/SQL?
Does execute immediate commit?
how to convert numeric values to character strings? : Sql dba
Which sql most popular?
What is number function in sql?
What is the use of function in sql?
Is sql similar to python?
How do I run a sql trace?
