Differences between UNIQUE and DISTINCT in select statements
Answer Posted / cutepa1
Yeah Manoj, Thatz ok, UNIQUE as a constraint. But I like to
know about the diff while its usage in select statement. For
me it seems very similar to DISTINCT, can anyone give me if
there is any difference, please.
| Is This Answer Correct ? | 15 Yes | 15 No |
Post New Answer View All Answers
What is difference between ms sql and mysql?
Is hadoop a nosql?
What is sql profiling in oracle?
How many types of sql are there?
Explain character-manipulation functions?
What is column?
What is write ahead logging in sql server?
what are different types of collation sensitivity? : Sql dba
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
Name the operator which is used in the query for pattern matching?
How does an execution block start and end in pl sql?
Can we create foreign key without primary key?
What is the use of %rowtype?
What is pl sql script?
How do I find sql profiler?