Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 136460 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / pravin d. survase
UNIQUE is only used in oracle but,
DISTINCT is used in all RDBMS.
UNIQUE is used in SELECT statement and as KEY also.
DISTINCT is only used in SELECT.
DISTINCT KEY concept is not present in SQL/ORACLE.
UNIQUE also supress the duplicates but, UNIQUE KEY will
allow the duplicates.
DISTINCT supress the duplicates.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
what are the non-standard sql commands supported by 'mysql'? : Sql dba
How to disable a trigger name update_salary?
What are the uses of merge?
What is a dirty read sql?
What is rename in sql?
Does google use sql?
what is subquery? : Sql dba
What is varray in pl sql?
How many types of literals are available in pl sql?
How is use pl and sql?
Is sql workbench free?
What is #table in sql?
how to use 'mysql' to run sql statements? : Sql dba
Is sqlite thread safe?
How to know the last executed procedure?
