Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 131353 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 is java sql connection?
What is the difference between delete and truncate statement in sql?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
How does one load ebcdic data? : aql loader
how can we know the count/number of elements of an array? : Sql dba
What is cross join sql?
How do I quit sql?
What are the indexing methods?
which types of join is used in sql widely? : Sql dba
What are sql functions? Describe in brief different types of sql functions?
How do I view a sql trace file?
How to run sql functions in pl/sql?
What is trigger explain it?
What are secondary keys?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
