Differences between UNIQUE and DISTINCT in select statements
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
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
Can we perform dml on view?
What will you get by the cursor attribute sql%found?
What is mutating error?
What are the different types of database management systems?
What is group function in sql?
define join and explain different type of joins? : Sql dba
What is the most common sql injection tool?
What is the difference between an inner and outer join?
Write the alter statement to enable all the triggers on the t.students table.
Why do we create views in sql?
How does a covering index work?
Can a foreign key be a duplicate?
what is heap table? : Sql dba
Explain the significance of the & and && operators in pl sql.