Differences between UNIQUE and DISTINCT in select statements
Answer Posted / satish parashar
After applying the unique clause all the value of column
will be sorted, But in distinct clause it only remove the
duplicacy from the table,not sorted the column value.
| Is This Answer Correct ? | 6 Yes | 15 No |
Post New Answer View All Answers
what is the difference between nested subquery and correlated subquery?
What is numeric function sql?
How many tables can you join in sql?
What is sql*plus?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
how to convert character strings to numeric values? : Sql dba
what is a composite key ? : Sql dba
what are the differences between char and nchar? : Sql dba
Does sqlite need a server?
Can one improve the performance of sql*loader? : aql loader
What are the different operators available in sql?
What does varchar include?
What is clustered index sql?
Can a procedure in a package be overloaded?