Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 131503 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / howard cheon
DISTINCT AND UNIQUE are same operation.
But, You cannot specify DISTINCT if the select_list
contains LOB columns.
| Is This Answer Correct ? | 16 Yes | 16 No |
Post New Answer View All Answers
Why cross join is used?
is it possible to pass an object or table to a procedure as an argument?
How do I start pl sql?
What does count (*) mean in sql?
what is the stuff function and how does it differ from the replace function? : Sql dba
Does user triggers have entry for trigger with compilation errors?
what is a materialized view? : Sql dba
How many tables can you join in sql?
What is sql procedures and functions?
How many times can we commit in a loop?
What is update query?
How do we use distinct statement? What is its use?
Explain ddl statements in pl/sql?
What type of database is sql?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
