Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 134509 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
How to combine two stored procedures in sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is recursive stored procedure?
What does pl sql developer do?
What are the set operators in sql?
What is pl sql collection?
How can check sql version from command line?
What is using in sql?
What is procedure and function?
What are the 3 types of behavioral triggers?
what is blob? : Sql dba
Advantages and disadvantages of stored procedure?
Is sql open source?
What is keys and its types?
Is sql procedural language?
