Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 131234 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / prabha
Distinct:
Its gives only the non duplicate values in a database table.
Unique:
The UNIQUE constraint uniquely identifies each record in a
database table.its similar to primary key.these values
cannot be repeated.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Can a procedure in a package be overloaded?
How does postgresql compare to oracle/db2/ms sql server/informix?
Do ddl statements need commit?
Where is pl sql used?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Can we use distinct and group by together?
What does the hierarchical profiler does?
Is pl sql a programming language?
What does sign mean sql?
What is a pl/sql block?
what does the t-sql command ident_current does? : Transact sql
What is the difference between sql, mysql and sql server?
What are all ddl commands?
what are the drivers in mysql? : Sql dba
Write a sql query to find the names of employees that begin with ‘a’?
