Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135708 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
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 range partitioning?
Which data dictionary views have the information on the triggers that are available in the database?
What does 0 mean in sql?
What are user defined functions?
What are different joins used in sql?
what is the difference between sql and t-sql? : Transact sql
What are the dml statements?
What is pl sql record in oracle?
what is unique key constraint? : Sql dba
How do you create an update query?
What are local and global Indexes and where they are useful.
What are tables in sql?
explain primary keys and auto increment fields in mysql : sql dba
Is sql similar to python?
What is set serveroutput on?
