Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 130957 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / manoj
UNIQUE(Constraint):- Can be only once for a column in a
table
DISTINCT(Clause):- Useed in select query to retrive distinct
(non repeated) data from table(s)
| Is This Answer Correct ? | 114 Yes | 68 No |
Post New Answer View All Answers
What is scope and visibility in PL/SQL?
What is the source code of a program?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
Are sql database names case sensitive?
What is a field in a database?
What are procedures used for?
Can we change the table name in sql?
what are ddl statements in mysql? : Sql dba
What are different types of sql commands?
what are tables and fields? : Sql dba
Why having clause is used in sql?
What is the use of triggers?
What is the need of merge statement?
When is the explicit cursor used ?
What is a loop in sql?
