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 are data types in pl sql?
what is the difference between inner and outer join? Explain with example. : Sql dba
How do you declare a constant?
What is pl sql block structure?
Can we join tables without foreign key?
how to use in conditions? : Sql dba
Does pdo prevent sql injection?
What is the difference between microsoft sql and mysql?
Is primary key always clustered index?
Is foreign key mandatory?
what are date and time intervals? : Sql dba
What are schema-level triggers?
What found sql?
What's the difference between inner join and left join?
What are stored procedures in mysql?