Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 131638 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
Why triggers are used?
What is embedded sql in db2?
what is 'mysqlimport'? : Sql dba
What is the primary use of normalization?
Show the cursor attributes of pl/sql.
What are the most important ddl statements in sql?
What is crud stand for?
Is sql scripting language?
Can we call a function containing dml statements in a select query?
What are the ways on commenting in a pl/sql code?
how to convert character strings to dates? : Sql dba
differentiate between float and double. : Sql dba
What is trigger with example?
Which kind of parameters cannot have a default value in pl sql?
What are pl/sql packages?
