Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 130915 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rob reid
Howard Cheon is correct. They are THE SAME. There is no
difference.
The following is from the Oracle 9i SQL Reference (Note the
statement "these two keywords are synonymous" - that means
they mean the same thing):
DISTINCT | UNIQUE
Specify DISTINCT or UNIQUE if you want Oracle to return
only one copy of each set of duplicate rows selected (these
two keywords are synonymous). Duplicate rows are those with
matching values for each expression in the select list.
Restrictions on DISTINCT and UNIQUE Queries
When you specify DISTINCT or UNIQUE, the total number of
bytes in all select list expressions is limited to the size
of a data block minus some overhead. This size is specified
by the initialization parameter DB_BLOCK_SIZE.
You cannot specify DISTINCT if the select_list contains LOB
columns.
| Is This Answer Correct ? | 59 Yes | 6 No |
Post New Answer View All Answers
What is the process of debugging?
What does the sign mean in sql?
what is a composite primary key ? : Sql dba
How do I enable sql encryption?
What are the different types of sql commands?
How many sql statements are used?
how many triggers are allowed in mysql table? : Sql dba
What does the hierarchical profiler does?
Write a query to find the names of users that begin with "um" in sql?
What is the difference between left join and right join?
Explain raise_application_error.
What is embedded sql with example?
What is the difference between execution of triggers and stored procedures?
Can you do multiple joins in sql?
how is myisam table stored? : Sql dba
