Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 131053 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / qman*
The two keywords are only synonymous in regards to a SELECT
statement, and also ONLY in an Oracle environment. DISTINCT
is an ANSI standard where as UNIQUE can only be used this
way in Oracle. To further the differences between the two,
UNIQUE may also be used in a table creation statement to
specify that inputs into the specified column cannot share
the same value, and if attempted will result in a
constraint violation error, I hope this clears things up.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What is rename command in sql?
What is the command used to fetch first 5 characters of the string?
Is json a nosql?
Is sql free?
What is the difference between a database and a relational database?
How many joins can you have in sql?
What is tuple in sql?
How to select 10 records from a table?
What is database migration?
Which sql statement is used to return only different values?
Does truncate free space?
Is and as keyword in pl sql?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is the difference between a primary key and a clustered index?
