Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135458 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
Is sql a programming?
What is difference between procedure and trigger?
What is trigger in pl sql with examples?
What are the popular database management systems in the it industry?
I need a function for a train ticket reservation please answer it thanks in advance
What do you mean by “trigger” in sql?
How do I run a program in pl sql?
Can we create a trigger on view?
Why use triggers in sql?
What is embedded sql in db2?
What is user defined functions?
Why stored procedure is better than query?
how to convert dates to character strings? : Sql dba
What is the limitation on the block size of pl/sql?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
