Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 134528 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 t string functions available in tsql? : Transact sql
Why self join is used in sql?
what are the types of subquery? : Sql dba
How do I audit the sql sent to the server?
What is the difference between join and natural join?
What is the usage of sql functions?
What is normalization sql?
What is a trigger in sql?
What are the three forms of normalization?
What are the types of join and explain each?
What are the triggers associated with image items?
What is the most common sql injection tool?
How many times can we commit in a loop?
What is a scalar value in sql?
Which is faster count (*) or count 1?
