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
how to write date and time literals? : Sql dba
What is data abstraction in sql?
How can we store rows in PL/SQL using array?
What does the acronym acid stand for in database management?
What is synchronized subquery?
Describe types of sql statements?
How do I view output in sql developer?
How do I start sql profiler?
Can unique keys be null?
How do I sort a table in sql?
Explain what is rdbms?
what is error ora-03113: end-of-file on communication channel?
Can we rollback delete command?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Which certification is best for sql?