Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135489 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 procedure and function?
Are left and right joins the same?
How do I save a stored procedure?
What are two statement types in sql?
How do you update a table in sql?
What are the different parts of a package?
What is a unique key?
What is the difference between function and procedure in pl/sql?
Is there a 64 bit version of ssms?
what is try_catch block in procedure
Why select is used in sql?
Differentiate between pl/sql and sql?
What is cold data?
Sql technical questions
How to run sql functions in pl/sql?
